Excel not letting me change Y axis bounds in scatter chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1970653%22%20slang%3D%22en-US%22%3EExcel%20not%20letting%20me%20change%20Y%20axis%20bounds%20in%20scatter%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1970653%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20an%20issue%20in%20that%20excel%20is%20not%20letting%20me%20start%20the%20Y%20axis%20of%20a%20scatter%20plot%20at%20a%20different%20value%20to%20zero.%20I%20cannot%20seem%20to%20find%20an%20option%20to%20turn%20off%20the%20automatic%20formatting.%20Any%20help%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22emma_1998_0-1607511511774.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239008i8054C1FE29C37CF3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22emma_1998_0-1607511511774.png%22%20alt%3D%22emma_1998_0-1607511511774.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1970653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1970838%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20letting%20me%20change%20Y%20axis%20bounds%20in%20scatter%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1970838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F895909%22%20target%3D%22_blank%22%3E%40emma_1998%3C%2FA%3E%26nbsp%3BYou%20should%20be%20able%20to%20just%20type%20the%20starting%20number%20where%20it%20says%200%2C0.%20Then%20the%20%22Auto%22%20will%20change%20to%20%22Reset%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1971005%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20letting%20me%20change%20Y%20axis%20bounds%20in%20scatter%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1971005%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BHi%2C%20this%20worked%20when%20I%20did%20the%20x%20axis%20but%20when%20I%20do%20the%20y%20axis%2C%20the%20number%20just%20jumps%26nbsp%3B%20back%20to%200.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. Any help would be greatly appreciated. 

emma_1998_0-1607511511774.png

 

8 Replies

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

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

@emma_1998 Strange. You should be able to over-ride the settings for both axis. See a quick-and-dirty X-Y chart attached.

 

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

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

I have exactly the same problem. I have an excel sheet that I have used for years to plot weight against date. I used to change the x-axis every half year by simply adding 183 to the bounds. But all of a sudden excel does not allow me to do that any more. I think it is a fault. Tried repair but no luck. Excel 2019, Windows 10, all up to date.