This documentation is archived and is not being maintained.

Charts Members 

A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.

The following tables list the members exposed by the Charts type.

  Name Description
Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Count Returns the number of objects in the collection. Read-only Integer.
Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
HPageBreaks Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only.
Item Returns a single object from a collection.
Parent Returns the parent object for the specified object. Read-only.
Visible Determines whether the object is visible. Read/write Object.
VPageBreaks Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only.

  Name Description
Add Creates a new chart sheet. Returns a Chart object.
Copy Copies the sheet to another location in the workbook.
Delete Deletes the object.
GetEnumerator Returns an enumerator to support iterating through the collection.
Move Moves the sheet to another location in the workbook.
PrintOut Prints the object.
PrintPreview Shows a preview of the object as it would look when printed.
Select Selects the object.