ChartObject.Chart Property

  • Article
Excel Developer Reference

Returns a Chart object that represents the chart contained in the object. Read-only.

Syntax

expression.Chart

expression   A variable that represents a ChartObject object.

Example

This example adds a title to the first embedded chart on Sheet1.

Visual Basic for Applications 
  With Worksheets("Sheet1").ChartObjects(1).Chart
    .HasTitle = True
    .ChartTitle.Text = "1995 Rainfall Totals by Month"
End With

See Also