ChartObject Members

Include Protected Members
Include Inherited Members

Represents an embedded chart on a worksheet.

The ChartObject type exposes the following members.

Properties

  Name Description
Public property 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).
Public property Border Returns a Border object that represents the border of the object.
Public property BottomRightCell Returns a Range object that represents the cell that lies under the lower-right corner of the object.
Public property Chart Returns a Chart object that represents the chart contained in the object.
Public property 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.
Public property Enabled True if the object is enabled.
Public property Height The height of the object.
Public property Index Returns the index number of the object within the collection of similar objects.
Public property Interior Returns an Interior object that represents the interior of the specified object.
Public property 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).
Public property Locked True if the object is locked, False if the object can be modified when the sheet is protected.
Public property Name Returns or sets the name of the object.
Public property OnAction Reserved for internal use.
Public property Parent Returns the parent object for the specified object.
Public property Placement Returns or sets the way the object is attached to the cells below it.
Public property PrintObject True if the object will be printed when the document is printed.
Public property ProtectChartObject True if the embedded chart frame cannot be moved, resized, or deleted.
Public property RoundedCorners True if the embedded chart has rounded corners.
Public property Shadow True if the font is a shadow font or if the object has a shadow.
Public property ShapeRange Returns a ShapeRange object that represents the specified object or objects.
Public property 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).
Public property TopLeftCell Returns a Range object that represents the cell that lies under the upper-left corner of the specified object.
Public property Visible Determines whether the object is visible.
Public property Width The width of the object.
Public property ZOrder Returns the z-order position of the object.

Top

Methods

  Name Description
Public method _Copy
Public method Activate Makes the current chart the active chart.
Public method BringToFront Brings the object to the front of the z-order.
Public method Copy Copies the object to the Clipboard. Copies a picture of the point or series to the Clipboard.
Public method CopyPicture Copies the selected object to the Clipboard as a picture.
Public method Cut Cuts the object to the Clipboard or pastes it into a specified destination.
Public method Delete Deletes the object.
Public method Duplicate Duplicates the object and returns a reference to the new copy.
Public method Select Selects the object.
Public method SendToBack Sends the object to the back of the z-order.

Top

See Also

Reference

ChartObject Interface

Microsoft.Office.Interop.Excel Namespace