TickMarkSpacing property (Excel Graph)

Returns or sets the number of categories or series between tick marks. Applies only to category and series axes. Read/write Long.

Syntax

expression.TickMarkSpacing

expression Required. An expression that returns one of the objects in the Applies To list.

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.

myChart.Axes(xlCategory).TickMarkSpacing = 10

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.