Auto-Scale

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am having problems with auto-scale automatically turning on. I have tried a
couple of different methods to turn it off. I have reinstalled the software.
I have had the user recreate the entire spreadsheet. I have tried suggestion
from Article ID: 215573. I have done everything I can think of and auto
scaling still keeps being turned on.
 
Hi,

I presume you mean the Auto options on the Scale tab?

Auto Scale is the default for all new charts, you can't change the default.
Auto scale automatically turns off when you type a value into the box to its
right. This is true even if the value you enter is the same one that was
there when Auto was on.

what you can do is create a template chart type that has pre entered values
on the Scale tab, thus overriding the Auto feature. When you create a new
chart use the template.

You create a chart template in 2003 by designing the chart and then choosing
Chart, Chart Type, Custom Type, User defined, Add....

And that is where you find it when you want to apply it.

If this helps, please click the Yes button

cheers,
Shane Devenshire
 
Sometimes people misunderstand the Format Axis dialog. In the scale tab,
when you enter a value for an axis scale parameter, Excel unchecks the Auto
box. If you go back and check this Auto box, Excel reverts to
autocalculating its own parameters. While it may seem silly that someone
would recheck the Auto box, I have seen it enough times, done by intelligent
people, to suspect it in a case like this.

- Jon
 
Back
Top