Share via

ChartObjects Object Members

  • Article
Excel Developer Reference

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

Methods

  Name Description
Bb255903.methods(en-us,office.12).gif Add Creates a new embedded chart.
Bb255903.methods(en-us,office.12).gif Copy Copies the object to the Clipboard.
Bb255903.methods(en-us,office.12).gif CopyPicture Copies the selected object to the Clipboard as a picture. Variant.
Bb255903.methods(en-us,office.12).gif Cut Cuts the object to the Clipboard.
Bb255903.methods(en-us,office.12).gif Delete Deletes the object.
Bb255903.methods(en-us,office.12).gif Duplicate Duplicates the object and returns a reference to the new copy.
Bb255903.methods(en-us,office.12).gif Item Returns a single object from a collection.
Bb255903.methods(en-us,office.12).gif Select Selects the object.

Properties

  Name Description
Bb255903.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.
Bb255903.properties(en-us,office.12).gif Count Returns a Long value that represents the number of objects in the collection.
Bb255903.properties(en-us,office.12).gif Enabled True if the object is enabled. Read/write Boolean.
Bb255903.properties(en-us,office.12).gif Height Returns or sets a Double value that represents the height, in points, of the object.
Bb255903.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).
Bb255903.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255903.properties(en-us,office.12).gif ProtectChartObject Read/write
Bb255903.properties(en-us,office.12).gif ShapeRange Returns a ShapeRange object that represents the specified object or objects. Read-only.
Bb255903.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).
Bb255903.properties(en-us,office.12).gif Visible Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Bb255903.properties(en-us,office.12).gif Width Returns or sets a Double value that represents the width, in points, of the object.