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

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