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.