Forum Discussion

dvirant's avatar
dvirant
Copper Contributor
Feb 23, 2021

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 (...
Charting
excel
Copetin's avatar
Copetin
Copper Contributor
Mar 25, 2021
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's avatar
    Ray2023
    Copper Contributor
    Apr 13, 2023
    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).
    • peter1360's avatar
      peter1360
      Copper Contributor
      Oct 23, 2024
      I 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.
  • carlepy's avatar
    carlepy
    Copper Contributor
    Dec 02, 2021

    Copetin still didn't work... do you have any idea of something else I might do? 

    honestly, I think this shouldn't be that hard....

    • Derek_Springett's avatar
      Derek_Springett
      Copper Contributor
      Feb 10, 2023

      carlepy 

      I have recently had two crazy problems. This was one of them. In both cases the solution was to close Teamviewer!

  • LostStudent's avatar
    LostStudent
    Copper Contributor
    Sep 12, 2021

    Copetin 

    I had the same issue and as soon as I started to read your solution, it clicked in my head, I changed the decimal definition in the past for working on something else - and I would never figure it out on my own, that is the issue with plotting. 

    It helped super a lot!

     

    Thank you!! 

  • rubenapu's avatar
    rubenapu
    Copper Contributor
    Aug 13, 2021
    It worked for me. Thanks!!
  • Jehanness's avatar
    Jehanness
    Copper Contributor
    Jun 30, 2021

    Copetin I also created an account just to thank you, i indeed though it had to do with the , & . but didnt know this was the case. Salute!

  • AinVit's avatar
    AinVit
    Copper Contributor
    May 18, 2021
    Tnx
  • Liz_IR's avatar
    Liz_IR
    Copper Contributor
    May 11, 2021
    I have this problem as well. I went into the Advanced options and deselected the Use system separators option, then saved and closed the spreadsheet. Unfortunately, when I reopened it, and selected format axis, I still can't see the bounds/units. Is there something more/different I should be doing? Thank you.
    • rdinatale's avatar
      rdinatale
      Copper Contributor
      Jun 15, 2021

      Liz_IR - Were you ever able to figure out a solution? Noting that I'm running into the exact same issue as you and am not finding that the fix works that Copetin shared about enabling "Use system separators."

       

      Please let me know if you came to a solution around this so that you can update the minimum value of your axis without the value automatically updating back to its original value.

      • Liz_IR's avatar
        Liz_IR
        Copper Contributor
        Jun 15, 2021
        I was able to see the bounds/units under axis options but there may have been a systematic fix as i did not change the way i was trying to set bounds (sorry that isn't very helpful). Best of luck
  • Morwen2280's avatar
    Morwen2280
    Copper Contributor
    Apr 18, 2021
    I've created an account just to say THANK YOU! Don't know how you found that, but you saved the day.
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 25, 2021
    I am pleased that you have found a solution.
    The main thing is that you have a solution and that we all have learned something :)).

    Thank you

    Nikolino
    The more I know, the more I realize that I don't know anything.
    (Albert Einstein freely based on Socrates)

Resources