Microsoft Office Tutorials and References
In Depth Information The TickLabels object
xlTickMarkCross = 4
End Enum
The TickMarkSpacing property returns or sets the number of categories or series between tick
marks. This applies only to category and series axes (for 3-D charts). To set the tick mark spacing
on a value axis, we can use the MajorUnit and MinorUnit properties (described later in this
There are also several properties related to tick-mark labels. The TickLabels property returns a
TickLabels object that represents the tick-mark labels for the specified axis.
The TickLabelPosition property returns or sets the position of tick-mark labels on the specified
axis. It can be one of the following XlTickLabelPosition constants:
Enum XlTickLabelPosition
xlTickLabelPositionNone = -4142
xlTickLabelPositionLow = -4134
xlTickLabelPositionHigh = -4127
xlTickLabelPositionNextToAxis = 4
End Enum
The TickLabelSpacing property returns or sets the number of categories or series between
tickmark labels. This property applies only to category and series axes (for 3-D charts). Note that
Excel determines label spacing on all value axes. The TickLabels object
The TickLabels object represents the set of tick-mark labels for an axis. Note that this is not a
collection object; that is, there is no TickLabel object. Thus, the properties of the TickLabels
object affect all of the labels for an axis simultaneously.
The TickLabels object has several properties, the most prominent of which are the following:
Returns a Font object that can be used to set the font characteristics of the labels.
Scales the label text font size automatically when the chart size changes when this
property is True . The default value is True .
Sets the number-format code for the labels. This property returns Null if all labels do not
have the same number format. Note that since the format codes are the same as those used
by Excel to format worksheet cells, we can use the macro recorder to get appropriate
format codes.
Returns or sets the orientation for the labels and can be any one of the following constants:
Enum XlTickLabelOrientation
xlTickLabelOrientationUpward = -4171
Search JabSto ::

Custom Search