ChartTitle Object

                  Properties         Methods        

Chart object
ChartTitle object
Border object
Characters object
Font object
Interior object

Represents the chart title.

Using the ChartTitle Object

Use the ChartTitle property to return the ChartTitle object. The following example adds a title to embedded chart one on the worksheet named "Sheet1."

With Worksheets("sheet1").ChartObjects(1).Chart
    .HasTitle = True
    .ChartTitle.Text = "February Sales"
End With

Remarks

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