ChartTitle Object

Microsoft Excel Visual Basic

previous page next page

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.

previous page start next page