Disable AutoScale for X and Y Axis

J

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
 
D

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
 
J

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
 
Top