ChartTitle Object

Microsoft Excel Visual Basic

previous page next page
ChartChartTitle
Multiple objects

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.

previous page start next page