Axis.TickMarkSpacing Property (Excel)
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