ChartObject Object Members

  • Article
Excel Developer Reference

Represents an embedded chart on a worksheet.

Methods

  Name Description
Bb255900.methods(en-us,office.12).gif Activate Makes the current chart the active chart.
Bb255900.methods(en-us,office.12).gif BringToFront Brings the object to the front of the z-order.
Bb255900.methods(en-us,office.12).gif Copy Copies the object to the Clipboard.
Bb255900.methods(en-us,office.12).gif CopyPicture Copies the selected object to the Clipboard as a picture.
Bb255900.methods(en-us,office.12).gif Cut Cuts the object to the Clipboard.
Bb255900.methods(en-us,office.12).gif Delete Deletes the object.
Bb255900.methods(en-us,office.12).gif Duplicate Duplicates the object and returns a reference to the new copy.
Bb255900.methods(en-us,office.12).gif Select Selects the object.
Bb255900.methods(en-us,office.12).gif SendToBack Sends the object to the back of the z-order.

Properties

  Name Description
Bb255900.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property 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). Read-only.
Bb255900.properties(en-us,office.12).gif BottomRightCell Returns a Range object that represents the cell that lies under the lower-right corner of the object. Read-only.
Bb255900.properties(en-us,office.12).gif Chart Read-only
Bb255900.properties(en-us,office.12).gif Enabled True if the object is enabled. Read/write Boolean.
Bb255900.properties(en-us,office.12).gif Height Returns or sets a Double value that represents the height, in points, of the object.
Bb255900.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb255900.properties(en-us,office.12).gif Left Returns or sets a Double value that represents the distance, in points, 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).
Bb255900.properties(en-us,office.12).gif Locked Returns or sets a Boolean value that indicates if the object is locked.
Bb255900.properties(en-us,office.12).gif Name Returns a String value representing the name of the object.
Bb255900.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255900.properties(en-us,office.12).gif Placement Returns or sets a Variant value, containing an XlPlacement constant, that represents the way the object is attached to the cells below it.
Bb255900.properties(en-us,office.12).gif PrintObject True if the object will be printed when the document is printed. Read/write Boolean.
Bb255900.properties(en-us,office.12).gif ProtectChartObject True if the embedded chart frame cannot be moved, resized, or deleted through the user interface. Read/write Boolean.
Bb255900.properties(en-us,office.12).gif RoundedCorners True if the embedded chart has rounded corners. Read/write Boolean.
Bb255900.properties(en-us,office.12).gif Shadow Returns or sets a Boolean value that determines if the font is a shadow font or if the object has a shadow.
Bb255900.properties(en-us,office.12).gif ShapeRange Returns a ShapeRange object that represents the specified object or objects. Read-only.
Bb255900.properties(en-us,office.12).gif Top Returns or sets a Double value that represents the distance, in points, 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).
Bb255900.properties(en-us,office.12).gif TopLeftCell Returns a Range object that represents the cell that lies under the upper-left corner of the specified object. Read-only.
Bb255900.properties(en-us,office.12).gif Visible Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Bb255900.properties(en-us,office.12).gif Width Returns or sets a Double value that represents the width, in points, of the object.
Bb255900.properties(en-us,office.12).gif ZOrder Returns the z-order position of the object. Read-only Long.