+ Reply to Thread
Results 1 to 6 of 6

can't change Min/max values in charts

  1. #1
    Registered User
    Join Date
    04-01-2021
    Location
    Latvija
    MS-Off Ver
    MS 2016
    Posts
    27

    can't change Min/max values in charts

    Hello! I have problem with my Excel! I can't change min/max values on axis chart? Can't find any solution in forums. Thank you!
    Attached Files Attached Files
    Last edited by Inese; 05-17-2021 at 10:14 AM.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: can't change Min/max values in charts

    You can double click on the axis or right click on axis and select Format Axis, in there at Axis Options - Bounds you can change them as needed.
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    04-01-2021
    Location
    Latvija
    MS-Off Ver
    MS 2016
    Posts
    27

    Re: can't change Min/max values in charts

    That is the problem! I can't change under Axis options, excel doesn't let me do this. I just reinstall my Microsoft Office. Even it start to calculate wrong equations. Like 1.1-1.045 it shows -1.044.
    Is there a problem related with something I can change manually in laptop?


    Screenshot 2021-05-13 155931.jpg

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,865

    Re: can't change Min/max values in charts

    You have not explained exactly what you are trying to do, but your screenshot shows that your axis is formatted as a logarithmic axis. In Excel 2003 and earlier, you were limited to even decades (10^n) for axis limits, but that limitation was relaxed in 2007. Even with those relaxations, logarithmic axes still have limitations (such as a logarithmic axis cannot have a minimum of 0 or less).

    Without knowing exactly what you are trying to do and why you have chosen a logarithmic axis, it is difficult to suggest a solution. At this point, help us understand why you have a logarithmic axis and what exactly you are trying to do. Perhaps then we can talk about how to move forward.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    04-01-2021
    Location
    Latvija
    MS-Off Ver
    MS 2016
    Posts
    27

    Re: can't change Min/max values in charts

    I have problem changing manually Axis Options - X/Y axis values. When I change the minimum/maximum value and I press enter to confirm the value it shows again the auto values - change back to the original. Excel doesn't allow values to be change.
    I think the issue not related with the file, because when I opened to other laptop it works!
    My laptops are running Win10/Office2016.
    I did complete reinstall Office, but still have the same issue.
    I have trayed to reset settings by regional tab, but still it takes to the auto bound again!
    Than you for your time! Hope to solved this annoying problem!
    Last edited by Inese; 05-14-2021 at 04:22 AM.

  6. #6
    Registered User
    Join Date
    04-01-2021
    Location
    Latvija
    MS-Off Ver
    MS 2016
    Posts
    27

    Re: can't change Min/max values in charts

    I solved the issue! For the record needed to reset regional additional settings, and in Excel File-->Options->Advanced -->Use system seperator, and restart computer!!!
    Thank you everyone for your time!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Command buttons to change Values in Charts
    By RoboRaz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2017, 04:12 PM
  2. [SOLVED] Vary Colors in Pivot Charts based on values (Overlay Charts)
    By TitansGo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-18-2017, 04:36 PM
  3. Need help getting column charts to change colour based on values
    By NPC1977 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-08-2012, 07:44 PM
  4. [SOLVED] macro to change charts by name
    By katto01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2012, 10:19 AM
  5. VBA to change a charts name
    By cklein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2012, 09:51 AM
  6. Replies: 3
    Last Post: 06-08-2012, 10:17 PM
  7. Replies: 0
    Last Post: 03-20-2007, 07:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1