ChartTitle object (Excel)

Represents the chart title.

Remarks

Use the ChartTitle property of the Chart object to return the ChartTitle object.

The ChartTitle object doesn't exist and cannot be used unless the HasTitle property for the chart is True.

Example

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

Methods

• Delete
• Select

Properties

• Application
• Caption
• Characters
• Creator
• Format
• Formula
• FormulaLocal
• FormulaR1C1
• FormulaR1C1Local
• Height
• HorizontalAlignment
• IncludeInLayout
• Left
• Name
• Orientation
• Parent
• Position
• ReadingOrder
• Shadow
• Text
• Top
• VerticalAlignment
• Width

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.