ChartTitle Object

Description

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.

Properties

Application property, AutoScaleFont property, Border property, Caption property, Characters property, Creator property, Fill property, Font property, HorizontalAlignment property, Interior property, Left property, Name property, Orientation property, Parent property, ReadingOrder property, Shadow property, Text property, Top property, VerticalAlignment property.

Methods

Delete method, Select method.