Axis.TickMarkSpacing Property

Syntax

expression.TickMarkSpacing

expression A variable that represents an Axis object.

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.

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

Alter tickmarks to be certain number of units apart? Specify number of categories between tick marks? Specify spacing on category axis tick marks? tick mark spacing Tick Mark Spacing Property Tickmark TickMarkSpacing TickMarkSpacing Property

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.

See also: