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

Series and SeriesCollection Members

Use the SeriesCollection to get all of the series plotted on the chart. Use the Chart object’s SeriesCollection property to get a reference to this collection. Use the Series object to change an individual series or get the data points that the series plots. The SeriesCollection and Series object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

 

2 Object and collection

 

Add 1

Application 2

ApplyCustomType

ApplyDataLabels

ApplyPictToEnd

ApplyPictToFront

ApplyPictToSides

AxisGroup

BarShape

Border

BubbleSizes

ChartType

ClearFormats

Copy

Count 1

Creator 2

DataLabels

Delete

ErrorBar

ErrorBars

Explosion

Extend 1

Fill

Formula

FormulaLocal

FormulaR1C1

FormulaR1C1Local

Has3DEffect

HasDataLabels

HasErrorBars

HasLeaderLines

Interior

InvertIfNegative

Item 1

LeaderLines

MarkerBackgroundColor

MarkerBackgroundColorIndex

MarkerForegroundColor

MarkerForegroundColorIndex

MarkerSize

MarkerStyle

Name

NewSeries 1

Parent 2

Paste 2

PictureType

PictureUnit

PlotOrder

Points

Select

Shadow

Smooth

Trendlines

Type

Values

XValues

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