TickMarkSpacing Property [Excel 2003 VBA Language Reference]

  • Article

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.

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

Applies to | Axis Object

See Also | MajorTickMark Property | MajorUnit Property | MinorTickMark Property | MinorUnit Property | TickLabelPosition Property | TickLabels Property | TickLabelSpacing Property