AxisTitle object (Excel)
Represents a chart axis title.
Remarks
Use the AxisTitle property of the Axis object to return an AxisTitle object.
The AxisTitle object doesn't exist and cannot be used unless the HasTitle property for the axis is True.
Example
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
Methods
Properties
- Application
- Caption
- Characters
- Creator
- Format
- Formula
- FormulaLocal
- FormulaR1C1
- FormulaR1C1Local
- Height
- HorizontalAlignment
- IncludeInLayout
- Left
- Name
- Orientation
- Parent
- Position
- ReadingOrder
- Shadow
- Text
- Top
- VerticalAlignment
- Width
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.