AxisTitle Object

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Axis
Aa612946.parchild(en-us,office.10).gifAxisTitle
Aa612946.space(en-us,office.10).gifAa612946.parchild(en-us,office.10).gif

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.