ChartTitle Object [Excel 2003 VBA Language Reference]
Chart ChartTitle 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.
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