changing vertical data

[andy_tap]

Hi

I select range E34:E38 in which the cells are all 98% as a set target value.The data is displayed in the vertical axis of the graph and starts at 97% and goes up to 100.5%. (the data against this value in range D34:D38 are all 100%).

Is it possible to change the vertical range to show 60%,70%,80%,85%,90%,95%,100% and 110% instead of 97.00%,97.50%,98.00%,98.50%,99.00%,99.50%,100.00% and 100.5& without changing the values in E34:E38?

Thank you

[FDibbins]

Go into the axis scaling and set it manually there. You can set the upper and lower limits, as well as the interval

[andy_tap]

Thank you it works fine

[FDibbins]

Happy to help, and thanks for the feedback