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
The AxisTitle object doesn't exist and cannot be used unless the HasTitle property for the specified axis is True.