Axis.TickLabelSpacing Property

Excel Developer Reference

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

Syntax

expression.TickLabelSpacing

expression   A variable that represents an Axis object.

Remarks

Tick-mark label spacing on the value axis is always calculated by Microsoft Excel.

Example

This example sets the number of categories between tick-mark labels on the category axis in Chart1.

Visual Basic for Applications
Charts("Chart1").Axes(xlCategory).TickLabelSpacing = 10

See Also

• Axis Object
• Axis Object Members
• MajorTickMark Property
• MinorTickMark Property
• TickLabelPosition Property
• TickLabels Property
• TickMarkSpacing Property