Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    Bend, Oregon
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Chart Y-Axis Scale Won't 'Stick' (2000 SP-2)

    I have a chart (which includes a trend line) showing a percentage value over time. I have set the y-axis as the percentage (from 0 to 100) and the x-axis as the time (month of year). However, every time I save the chart, Excel has the audacity to change the scale to whatever it wants, instead of what I have set (Min: 0, Max: 1, Major: 0.2, Minor: 0.1). It also turns scale selections (checkboxes) on and off at will. What other options need setting in Excel to make the scale remain according to my desires?

    Jamie

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Chart Y-Axis Scale Won't 'Stick' (2000 SP-2)

    This is very strange. Once you turn off the "Automatic" check boxes, Excel should not bother with the values again.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Chart Y-Axis Scale Won't 'Stick' (2000 SP-2)

    I agree with Hans.

    Does it do it on all sheets in the file? On all workbooks you create?
    Do you have any code running in the worksheet that is modifying your chart?

    Steve

  4. #4
    Star Lounger
    Join Date
    Feb 2003
    Location
    Bend, Oregon
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Chart Y-Axis Scale Won't 'Stick' (2000 SP-2)

    The "Automatic" check boxes turned out to be the issue ... when the new head of IT learned of my problem, he discovered that the old IT supervisor had set up Excel on the server to ignore various "modifications" to it's settings. He has now corrected that issue and is in the process of reviewing all the application settings on the servers to insure that nobody has anything similar occur. Thanks for replying to my query -- Jamie

Posting Permissions

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