0 out of 1 rated this helpful - Rate this topic

Axis.TickLabelSpacing Property (Excel)

Published: July 16, 2012

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.

expression .TickLabelSpacing

expression A variable that represents an Axis object.

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

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

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.