ChartTitle Object

  • Article
Excel Developer Reference

Represents the chart title.

Remarks

Use the ChartTitle property to return the ChartTitle object.

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

Example
The following example adds a title to embedded chart one on the worksheet named "Sheet1."

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

See Also