Chart and Charts Members

Use the Charts collection to add chart sheets to a workbook. Use the Workbook object’s Charts property to get a reference to this collection. Use the Chart object to plot numeric data graphically. The Charts collection and Chart object have many of the same members as the Worksheets collection and Worksheet object. Key members that are unique to charts (shown in bold)are covered in the following reference section:

Add 1

Application 2

ApplyCustomType

1 Collection only

2 Object and collection

ApplyDataLabels

Area3DGroup

AreaGroups

AutoFormat

AutoScaling

Axes

Bar3DGroup

BarGroups

BarShape

ChartArea

ChartGroups

ChartObjects

ChartTitle

ChartType

ChartWizard

CheckSpelling

CodeName

Column3DGroup

ColumnGroups

Copy 2

CopyPicture

Corners

Count 1

CreatePublisher

Creator 2

DataTable

Delete 2

DepthPercent

Deselect

DisplayBlanksAs

DoughnutGroups

Elevation

Evaluate

Export

Floor

GapDepth

GetChartElement

HasAxis

HasDataTable

HasLegend

HasPivotFields

HasTitle

HeightPercent

HPageBreaks 1

Hyperlinks

Index

Item 1

Legend

Line3DGroup

LineGroups

Location

MailEnvelope

Move 2

Name

Next

OLEObjects

PageSetup

Parent 2

Paste

Perspective

Pie3DGroup

PieGroups

PivotLayout

PlotArea

PlotBy

PlotVisibleOnly

Previous

PrintOut 2

PrintPreview ...

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.

Start your free trial