XlTickMark can be one of these XlTickMark constants. |
xlTickMarkInside |
xlTickMarkOutside |
xlTickMarkCross |
xlTickMarkNone |
expression.MajorTickMark
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets the major tick marks for the value axis in Chart1 to be outside the axis.
Charts("Chart1").Axes(xlValue).MajorTickMark = xlTickMarkOutside