Charts Collection Object

Description

A collection of all the chart sheets in the specified or active workbook. This does not include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the Chart or ChartObject objects.

Accessors

Use the Add method to create a new chart sheet and add it to the workbook. The following example adds a new chart sheet to the active workbook and places the new chart sheet after the worksheet named "Sheet1."


Charts.Add after:=Worksheets("sheet1")

You can combine the Add method with the ChartWizard method to add a new chart containing data from a worksheet. The following example adds a new line chart based on data in cells A1:A20 on the worksheet named "Sheet1."


With Charts.Add
    .ChartWizard source:=Worksheets("sheet1").Range("a1:a20"), _
        gallery:=xlLine, title:="February Data"
End With

Use the Charts method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

The Sheets collection contains all of the sheets in the workbook (chart sheets, dialog sheets, modules, and worksheets). Use the Sheets method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

Properties

Application Property, Count Property, Creator Property, Parent Property, Visible Property.

Methods

Add Method (Charts Collection), Copy Method, Delete Method, Item Method, Move Method, PrintOut Method, PrintPreview Method, Select Method.