MajorUnit Property

Returns or sets the major units for the axis. Read/write Double.

Setting this property sets the MajorUnitIsAuto property to False.

Use the TickMarkSpacing property to set tick-mark spacing on the category axis.

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

With myChart.Axes(xlValue) 
 .MajorUnit = 100 
 .MinorUnit = 20 
End With