This documentation is archived and is not being maintained.

ChartObject Members 

Represents an embedded chart on a worksheet.

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

  Name Description
Application Returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object).
Border Returns a Border object that represents the border of the object.
BottomRightCell Returns a Range object that represents the cell that lies under the lower-right corner of the object.
Chart Returns a Chart object that represents the chart contained in the object.
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.
Enabled True if the object is enabled.
Height The height of the object.
Index Returns the index number of the object within the collection of similar objects.
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.
Name Returns or sets the name of the object.
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.
ProtectChartObject True if the embedded chart frame cannot be moved, resized, or deleted.
RoundedCorners True if the embedded chart has rounded corners.
Shadow True if the font is a shadow font or 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).
TopLeftCell Returns a Range object that represents the cell that lies under the upper-left corner of the specified object.
Visible Determines whether the object is visible.
Width The width of the object.
ZOrder Returns the z-order position of the object.

  Name Description
Activate Makes the current chart the active chart.
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.
Select Selects the object.
SendToBack Sends the object to the back of the z-order.