AxisTitle Object
Description
Represents a chart axis title.
Using the AxisTitle Object
Use the AxisTitle property to return an AxisTitle object. The following example activates embedded chart one, sets the value axis title text, sets the font to Bookman 10 point, and formats the word "millions" as italic.
Worksheets("sheet1").ChartObjects(1).Activate
With ActiveChart.Axes(xlValue)
.HasTitle = True
With .AxisTitle
.Caption = "Revenue (millions)"
.Font.Name = "bookman"
.Font.Size = 10
.Characters(10, 8).Font.Italic = True
End With
End With
Remarks
The AxisTitle object doesn't exist and cannot be used unless the HasTitle property for the axis is True.
Properties
Application property, AutoScaleFont property, Border property, Caption property, Characters property, Creator property, Fill property, Font property, HorizontalAlignment property, Interior property, Left property, Name property, Orientation property, Parent property, ReadingOrder property, Shadow property, Text property, Top property, VerticalAlignment property.
Methods
Delete method, Select method.