MajorTickMark Property 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