AxisTitle Object [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
AxisTitle Object
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.

Visual Basic for Applications
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


Community Content

nzadmin
AxisTitle.Characters property does not work as expected
If you try to run the sample code given in this article, you will find that the entire axis title, not only the word "millions" is italicized. The same problem happens if you try to superscript one character of the title. The problem occurs both in VBA and in VB 2008.

I've also found the same thing in the chart title.