Share via

AxisTitle Object (Excel)

  • Article

Represents a chart axis title.

Remarks

Use the AxisTitle property to return an AxisTitle object.

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

Example

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

See Also

Concepts

Excel Object Model Reference

AxisTitle Object Members