AxisAxisTitle
Multiple objects
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.