ChartTitle Object [Excel 2003 VBA Language Reference]

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


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

Parent Objects | Chart Object

Child Objects | Border Object | Characters Object | ChartFillFormat Object | Font Object | Interior Object