TickLabelSpacing Property Example
This example sets the number of categories between tick-mark labels on the category axis in Chart1.
Charts("Chart1").Axes(xlCategory).TickLabelSpacing = 10