Forum Discussion
dvirant
Feb 23, 2021Copper Contributor
Cannot change axis bounds
I hope this is the right place to ask, but I have an issue with Excel 2016. When I plot a graph, Excel won't let me change the axes minima and maxima. I can enter a value into the respective fields (...
Copetin
Mar 25, 2021Copper Contributor
Hey guys (@dvirant , NikolinoDE , robalten242 , WFRAI ) !!!! I was looking at the excel configuration and nearly by chance I found the solution.... it's gonna sound unbelievable but it was this silly. Apparently the error appears when you don't have well defined the decimal and grouping symbol in your system in the Additional settings in the Region tab of the control panel of windows (I'd never changed anything there so honestly I don't know if it was an update that generated that change or what...) so in the excel options ( in the advanced tab) we all have the default setting that is "Use system separators" and that was messing everything up because every time we wrote excel detected that it was not the correct format and take it to the auto bound again. Give it a try and tell me how it went. 😉
Ray2023
Apr 13, 2023Copper Contributor
Does anyone know a solution to the same problem in Excel for Mac, Home 2021, operating on a Mac miniM2 with Ventura 13.2? There doesn't appear to be any solution close to what Copetin describes for Windows (very different command tree from Mac). (My 2011 iMac didn't have this problem with Office 2008.) Thanks for any help (even Thoughts & Prayers).
- peter1360Oct 23, 2024Copper ContributorI have a very similar problem, Excel for Mac, Home, 2021. I think it only happens with dates in the x-axis. If I enter 8/9/24 as the lower bound (dd/mm/yy format), it gets changed to 9/9/28. Entering 31/10/24 gets changed to 1/11/28.