MinimumScaleIsAuto 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