SeriesCollection SeriesCollection SeriesCollection Interface

Definition

A collection of all the Series objects in the specified chart or chart group.

public interface class SeriesCollection : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("0002086C-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SeriesCollection : System.Collections.IEnumerable
Public Interface SeriesCollection
Implements IEnumerable
Attributes
Implements

Remarks

Use the SeriesCollection(Object) method to return the SeriesCollection collection.

Use the Add(Object, XlRowCol, Object, Object, Object) method to create a new series and add it to the chart.

Use SeriesCollection(index), where index is the series index number or name, to return a single Series object.

Properties

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Count Count Count

Returns the number of objects in the collection.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Parent Parent Parent

Returns the parent object for the specified object.

Methods

_Default(Object) _Default(Object) _Default(Object)

Reserved for internal use.

Add(Object, XlRowCol, Object, Object, Object) Add(Object, XlRowCol, Object, Object, Object) Add(Object, XlRowCol, Object, Object, Object)

Adds one or more new series to the SeriesCollection collection.

Extend(Object, Object, Object) Extend(Object, Object, Object) Extend(Object, Object, Object)

Adds new data points to an existing series collection.

GetEnumerator() GetEnumerator() GetEnumerator()
Item(Object) Item(Object) Item(Object)

Returns a single object from a collection.

NewSeries() NewSeries() NewSeries()

Creates a new series. Returns a Series object that represents the new series.

Paste(XlRowCol, Object, Object, Object, Object) Paste(XlRowCol, Object, Object, Object, Object) Paste(XlRowCol, Object, Object, Object, Object)

Pastes data from the Clipboard into the specified series collection.

Applies to