Hi, I am having trouble with my chart line scaling correctly. I have 2 variables to control what want to see on my chart...
1. "Start From # Rows Down" - which controls my starting point (ie my row I want to start from)
2. "Data Points" - which controls how many rows of data I want to display.
The chart scaling is set to automatic. However it looks as I want to when you open the file attached eg the chart is set to the min and max values +/- a small amount. Now if you change the either of the 2 values in the highlighted cells to a greater value, the scaling makes the min value go to zero an dthe max value go much higher, but I don't know why or how to prevent this as I want the scaling to be dynamic to the min/max values being displayed.
Can you offer a good solution?
regards
GB
1. "Start From # Rows Down" - which controls my starting point (ie my row I want to start from)
2. "Data Points" - which controls how many rows of data I want to display.
The chart scaling is set to automatic. However it looks as I want to when you open the file attached eg the chart is set to the min and max values +/- a small amount. Now if you change the either of the 2 values in the highlighted cells to a greater value, the scaling makes the min value go to zero an dthe max value go much higher, but I don't know why or how to prevent this as I want the scaling to be dynamic to the min/max values being displayed.
Can you offer a good solution?
regards
GB