Axis.MinorUnitIsAuto Property (Excel)

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

Syntax

expression. MinorUnitIsAuto

expression A variable that represents an [Axis](./Excel.Axis(Graph object).md) object.

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

See also

Axis Object