Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

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.
OnAction  
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.
Top

  Name Description
_Dummy12  
_Dummy15  
_Dummy22  
_Dummy25  
_Dummy27  
_Dummy28  
_Dummy29  
_Dummy3  
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.
Group  
Item Returns a single object from a collection.
Select Selects the object.
SendToBack Sends the object to the back of the z-order.
Top

Community Additions

ADD
Show:
© 2015 Microsoft