Charts Property

Applies To

Application object, Workbook object.

Description

Application object: Returns a Sheets collection that represents all the chart sheets in the active workbook. Read-only.

Workbook object: Returns a Sheets collection that represents all the chart sheets in the specified workbook. Read-only.

Using this property without an object qualifier returns all chart sheets in the active workbook.

See Also

ChartObjects method.

Example

This example sets the text for the title of Chart1.

With Charts("Chart1")
    .HasTitle = True
    .ChartTitle.Text = "First Quarter Sales"
End With

This example deletes every chart sheet in the active workbook.

ActiveWorkbook.Charts.Delete

This example hides Chart1, Chart3, and Chart5.

Charts(Array("Chart1", "Chart3", "Chart5")).Visible = False