Chart.AutoScaling Property

Excel Developer Reference

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.

Syntax

expression.AutoScaling

expression   A variable that represents a Chart object.

Example

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

Visual Basic for Applications
  With Charts("Chart1")
    .RightAngleAxes = True
    .AutoScaling = True
End With

See Also