ChartTitle Object

Chart ChartTitle
Border
Characters
Font
Interior

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.