Axis.TickMarkSpacing Property

Returns or sets the number of categories or series between tick marks. Applies only to category and series axes. Can be a value from 1 through 31999. Read/write Long.

Syntax

expression.TickMarkSpacing

expression   A variable that represents an Axis object.

Remarks

Use the MajorUnit and MinorUnit properties to set tick-mark spacing on the value axis.

Example

This example sets the number of categories between tick marks on the category axis in Chart1.

  Charts("Chart1").Axes(xlCategory).TickMarkSpacing = 10

See Also

• Axis Object
• Axis Object Members
• MajorTickMark Property
• MajorUnit Property
• MinorTickMark Property
• MinorUnit Property
• TickLabelPosition Property
• TickLabels Property
• TickLabelSpacing Property