ChartObject and ChartObjects Members

Use the ChartObjects collection to embed new charts on a worksheet or get existing embedded charts. Use the Worksheet or Chart object’s ChartObjects property to get a reference to this collection. Use the individual ChartObject to get a reference to the underlying Chart object for the embedded chart. ChartObjects and ChartObject have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Activate

Add 1

Application 2

Border 2

BottomRightCell

BringToFront 2

Chart

Copy 2

CopyPicture 2

Count 1

Creator 2

Cut 2

Delete 2

Duplicate 2

Enabled 2

Group 1

Height 2

Index

Interior 2

Item 1

Left 2

Locked 2

Name

Parent 2

Placement 2

PrintObject 2

ProtectChartObject

RoundedCorners 2

Select 2

SendToBack 2

Shadow 2

ShapeRange 2

Top 2

TopLeftCell

Visible 2

Width 2

ZOrder

 

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.