and MinorUnit
properties to set tick-mark spacing on value axes. Read/write Long.
expression.TickMarkSpacing
expression Required. An expression that returns a ChAxis object.
Example
This example sets the number of categories between tick marks on the specified axis to two.
ChartSpace1.Charts(0).Axes(1).TickMarkSpacing = 2