Microsoft Office Tutorials and References
In Depth Information
21.6 The Axis Object
Border
Returns a Border object that can be used to set the color, line style, and width of the
border of the axis title.
Caption
Sets the text for the title.
Characters
Returns a Characters object, which is a range of characters in the caption. This allows us
to format a portion of the text in the caption.
Fill
Returns a ChartFillFormat object used to set fill-formatting properties for the axis title.
Font
Returns a Font object that can be used to set the font characteristics of the labels.
HorizontalAlignment and VerticalAlignment
Sets the alignment of axis title text.
Interior
Returns an Interior object that can be used to format the interior of the axis title area.
NumberFormat
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.
Orientation
Returns or sets the orientation for the axis title. It can be any one of the following
constants:
Enum XlOrientation
xlUpward = -4171
xlDownward = -4170
xlVertical = -4166
xlHorizontal = -4128
End Enum
Let us take a closer look at the Characters object. A Characters object represents a contiguous
portion of text within a text string. The Characters property returns a Characters object. (Note that
the Characters property also applies to the ChartTitle object and the Range object.)
The syntax of the Characters property is:
Search JabSto ::




Custom Search