Returns or sets the number of categories between tick-mark labels for the specified axis. Applies only to category axes. Read/write Long.
expression.TickLabelSpacing
expression Required. An expression that returns a ChAxis object.
This example sets the number of categories between tick-mark labels for the specified axis to two.
ChartSpace1.Charts(0).Axes(1).TickLabelSpacing = 2