Chart Object Properties

Name

Returns

Description

BottomRight Cell

Range

Read-only. Returns the single cell range located under the lower-right corner of the ChartObject

Chart

Chart

Read-only. Returns the actual chart associated with the ChartObject

Enabled

Boolean

Set/Get whether a macro associated with the ChartObject is capable of being triggered

Height

Double

Set/Get the height of embedded chart

Index

Long

Read-only. Returns the position of the ChartObject among the parent collection

Left

Double

Set/Get the distance from the left edge of the ChartObject to the left edge of the parent sheet

Locked

Boolean

Set/Get whether the ChartObject is locked when the parent sheet is protected

Name

Returns

Description

Name

String

Set/Get the name of the ChartObject

Placement

XlPlacement

Set/Get how the ChartObject object is anchored to the sheet (for example, free floating, move with cells). Use the XlPlacement constants to set this property

PrintObject

Boolean

Set/Get whether the embedded chart on the sheet will be printed when the sheet is printed

ProtectChart Object

Boolean

Set/Get whether the embedded chart can change sizes, can be moved, or can be deleted from the parent sheet

Rounded Corners

Boolean

Set/Get whether the corners of the embedded chart are rounded (True) or right angles (False)

Shadow

Boolean

Set/Get whether a shadow appears around the embedded chart

ShapeRange

ShapeRange

Read-only. Returns the ChartObject as a Shape object

Top

Double

Set/Get the distance from top edge of the ChartObject to the top of the parent sheet

TopLeftCell

Range

Read-only. Returns the single cell range located above the top-left corner of the ChartObject

Visible

Boolean

Set/Get whether the ChartObject object is visible

Width

Double

Set/Get the width of embedded chart

ZOrder

Long

Read-only. Returns the position of the embedded chart among all the other objects on the sheet. The ZOrder also matches the location of the ChartObject in the parent collection

0 0

Post a comment