MinorUnitIsAuto Property [Excel 2003 VBA Language Reference]

  • Article

True if Microsoft Excel calculates minor units for the value axis. Read/write Boolean.

Remarks

Setting the MinorUnit property sets this property to False.

Example

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

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

Applies to | Axis Object

See Also | MajorUnit Property | MajorUnitIsAuto Property | MajorUnitScale Property | MinorUnit Property | MinorUnitScale Property