Forum Discussion
Excel not letting me change Y axis bounds in scatter chart
Hello, I am having an issue in that excel is not letting me start the Y axis of a scatter plot at a different value to zero. I cannot seem to find an option to turn off the automatic formatting. ...
Riny_van_Eekelen Hi, this worked when I did the x axis but when I do the y axis, the number just jumps back to 0.
That could be if instead of 0,8 you enter 0.8 (I guess comma is your default decimal part separator). With any incorrect value it silently jumps back to zero or to previous correctly entered number. On X-axis you have no decimal part for values, thus it worked since you didn't use comma or dot.