Disable AutoScale for X and Y Axis

[Jennifer Q]

Is there a way to turn AutoScale *off* as the default on X and Y axis when
creating charts in Excel 2003?

Thanks,
Jeni

 

[Don Guillett]

from vba help
AutoScaling Property
See Also Applies To Example Specifics
True if Microsoft Excel scales a 3-D chart so that it's closer in size to
the equivalent 2-D chart. The RightAngleAxes property must be True.
Read/write Boolean.

Example
This example automatically scales Chart1. The example should be run on a 3-D
chart.

With Charts("Chart1")
.RightAngleAxes = True
.AutoScaling = True
End With

 

[Jennifer Q]

Thanks Don,
I found that on MSDN too.

Am I to understand that I can use that chunk of code in a macro on a one-off
scnenario when I create a chart, or is this someting that I add to something
like the Personal.xls macro that will be automatically added to all new
charts I create?

Thanks,
Jennifer

 

[Don Guillett]

Either