MaximumScaleIsAuto Property Example
This example automatically calculates the minimum scale and the maximum scale for the value axis in Chart1.
With Charts("Chart1").Axes(xlValue)
.MinimumScaleIsAuto = True
.MaximumScaleIsAuto = True
End With