AxisTitle Object

Represents the title of an axis in a chart.

Using the AxisTitle Object

Use the AxisTitle property to return an AxisTitle object. The following example sets the text of the value axis title and sets the font to 10-point Bookman.

With myChart.Axes(xlValue)
    .HasTitle = True
    With .AxisTitle
        .Caption = "Revenue (millions)"
        .Font.Name = "bookman"
        .Font.Size = 10
    End With
End With
		

Remarks

The AxisTitle object doesn't exist and cannot be used unless the HasTitle property for the specified axis is True.