This documentation is archived and is not being maintained.

ChartObjects Members 

A collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.

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

  Name Description
Application Returns an Application object that represents the Microsoft Excel application.
Border Returns a Border object that represents the border of the object.
Count Returns the number of objects in the collection.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
Enabled True if the object is enabled.
Height The height of the object.
Interior Returns an Interior object that represents the interior of the specified object.
Left The distance from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
Locked True if the object is locked; False if the object can be modified when the sheet is protected.
Parent Returns the parent object for the specified object.
Placement Returns or sets the way the object is attached to the cells below it.
PrintObject True if the object will be printed when the document is printed.
RoundedCorners True if the embedded chart has rounded corners.
Shadow True if the object has a shadow
ShapeRange Returns a ShapeRange object that represents the specified object or objects.
Top The distance from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
Visible Determines whether the object is visible.
Width The width of the object.

  Name Description
Add Creates a new embedded chart. Returns a ChartObject object.
BringToFront Brings the object to the front of the z-order.
Copy Copies the object to the Clipboard. Copies a picture of the point or series to the Clipboard.
CopyPicture Copies the selected object to the Clipboard as a picture.
Cut Cuts the object to the Clipboard or pastes it into a specified destination.
Delete Deletes the object.
Duplicate Duplicates the object and returns a reference to the new copy.
GetEnumerator Returns an enumerator to support iterating through the collection.
Item Returns a single object from a collection.
Select Selects the object.
SendToBack Sends the object to the back of the z-order.