Forum Discussion

emma_1998

Copper Contributor

Dec 09, 2020

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. ...

Platinum Contributor

Dec 09, 2020

emma_1998 You should be able to just type the starting number where it says 0,0. Then the "Auto" will change to "Reset".

emma_1998
Copper Contributor
Dec 09, 2020
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.
- SergeiBaklan
  Diamond Contributor
  Dec 09, 2020
  emma_1998
  
  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.
- Riny_van_Eekelen
  Platinum Contributor
  Dec 09, 2020
  emma_1998 Strange. You should be able to over-ride the settings for both axis. See a quick-and-dirty X-Y chart attached.
  - emma_1998
    Copper Contributor
    Dec 09, 2020
    Riny_van_Eekelen Yes really strange, thanks for trying to help. Apparently it may be something faulty regarding excel so I am going to try repair the program and see what happens.