MajorUnitIsAuto Property Example

This example automatically sets the major and minor units for the value axis in Chart1.

With Charts("Chart1").Axes(xlValue)
    .MajorUnitIsAuto = True
    .MinorUnitIsAuto = True
End With