Syntax

expression.MajorUnit

expression A variable that represents an Axis object.

Remarks

Setting this property sets the property to False.

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

Example

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

Visual Basic for Applications 
With Charts("Chart1").Axes(xlValue) .MajorUnit = 100 .MinorUnit = 20 End With
Define each major gridline to be a certain number of units apart? Major unit Major Unit Property MajorUnit MajorUnit Property Retrieve the unit spacing between the main gridlines? Set the value difference between major gridlines?

See also: