MajorTickMark Property

Microsoft Excel Visual Basic

MajorTickMark Property

       

Returns or sets the type of major tick mark for the specified axis. Read/write XlTickMark.

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