Axis.MinorUnitIsAuto Property (Excel)

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


expression. MinorUnitIsAuto

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


Setting the MinorUnit property sets this property to False .


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