SeriesCollection

Description

The SeriesCollection class contains the set of data series in a worksheet.

C#

vb.net

To return a SeriesCollection object, use Chart.SeriesCollection.

Name	Description
CategoryData	Sets or Returns a formula referencing a range of cells (e.g. "A1:A5"). The values in these cells are used for the labels on the primary category (x) axis of the chart. For scatter and bubble charts, this property will return an empty string. To get the values used on the horizontal axis for a scatter or bubble series, use Series.ScatterValues instead.
Count	Returns the number of data series in the collection.
SecondaryCategoryData	Sets or Returns a formula referencing a range of cells (e.g. "A1:A5"). The values in these cells are used for the labels on the secondary category (x) axis of the chart.

Name	Description
Item(Int32)	Returns the Series at the specified index.

Name	Description
CreateSeries(Area)	Creates a new Series that is automatically added to the SeriesCollection. The series will be plotted on the primary axis, and its type will be the chart's ChartType.
CreateSeries(Area, ChartType, AxisType)	Creates a new Series that is automatically added to the SeriesCollection.
CreateSeries(Range)	Creates a new Series that is automatically added to the SeriesCollection. The series will be plotted on the primary axis, and its type will be the chart's ChartType.
CreateSeries(Range, ChartType, AxisType)	Creates a new Series that is automatically added to the SeriesCollection.
CreateSeries(String)	Creates a new Series that is automatically added to the SeriesCollection. The series will be plotted on the primary axis, and its type will be the chart's ChartType.
CreateSeries(String, ChartType, AxisType)	Creates a new Series that is automatically added to the SeriesCollection.
GetEnumerator()	Returns an IEnumerator for the SeriesCollection of a Chart
Remove(Int32)	Removes the specified Series from the collection.
Remove(Series)	Removes the specified Series from the collection.