TickLabelSpacing Property

Applies To

Axis Object.

Description

Returns or sets the number of categories or series between tick labels. Applies only to category and series axes. Read-write.

Remarks

This property applies to the category and series axes only. Label spacing on the value axis is always calculated by Microsoft Excel.

See Also

MajorTickMark Property, MinorTickMark Property, TickLabelPosition Property, TickLabels Property, TickMarkSpacing Property.

Example

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


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