Axis.TickLabelSpacing Property

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`

Return number of categories per tickmark label? Set the number of units between tick labels? tick label spacing Tick Label Spacing Property ticklabel TickLabelSpacing TickLabelSpacing Property

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.

See also: