Modifica

Condividi tramite


ChartObject Interface

Definition

Represents an embedded chart on a worksheet.

public interface class ChartObject
[System.Runtime.InteropServices.Guid("000208CF-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ChartObject
Public Interface ChartObject
Attributes

Remarks

The ChartObject object acts as a container for a Chart object. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the worksheet. The ChartObject object is a member of the ChartObjects collection. The ChartObjects collection contains all the embedded charts on a single sheet.

Properties

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.

OnAction

Reserved for internal use.

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.

Methods

_Copy()
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(XlPictureAppearance, XlCopyPictureFormat)

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(Object)

Selects the object.

SendToBack()

Sends the object to the back of the z-order.

Applies to