O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required