Turn off font Auto Scale globally in Excel 2003?

[Ted M H]

Is there a way to tell Excel globally to uncheck the Auto scale checkbox on
the font tab for all chart elements? Or at least turn it off for all
elements on the current chart? The default seems to be to have auto scale on
and the only thing I can figure out to deal with it is to turn off each chart
element's auto scale, one at a time. For my situation this is truly an
obnoxious default setting.

 

[Peter T]

Try first unchecking font auto scale with the "Chart Area" selected (the
outside of the chart).

You could set your chart preferences as the default chart type, see Chart
types, Custom types, User defined.

Regards,
Peter T

 

[Ted M H]

Aha! So when you set the auto scale option for the chart area font, you set
it globally for the chart. That's great! Using the user defined charts,
including the default chart type, is also a helpful idea. Thanks very much
for your help.

 

[Jon Peltier]

This tutorial shows how to uncheck the AutoScale box for all charts, going
forward (it doesn't fix any existing charts):

http://peltiertech.com/Excel/Charts/FixFonts.html

- Jon

 

[Ted M H]

Hi Jon,

I thought your name sounded familiar...You're listed in a J. Walkenbach book
where he says you have "an uncanny ability to solve practically any chart
related problem." Indeed you do!

So this is a celebrity response! How cool is that? Very much appreciate
you sharing your expertise. Thanks.