AxisTitle Object

Description

Represents an axis title in a chart.

Accessors

The AxisTitle property returns the axis title for the specified axis. The following example activates embedded chart one on the worksheet named "Sheet1," sets the value axis title text, sets the font to Bookman 10 point, and sets the word "millions" to italics.


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 does not exist and cannot be accessed unless the HasTitle property for the axis is True.

Properties

Application Property, Border Property, Caption Property, Creator Property, Font Property, HorizontalAlignment Property, Interior Property, Left Property, Name Property, Orientation Property, Parent Property, Shadow Property, Text Property, Top Property, VerticalAlignment Property.

Methods

Characters Method, Delete Method, Select Method.