SeriesCollection Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

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	Returns an Application object that represents the Microsoft Excel application.
Count	Returns the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Parent	Returns the parent object for the specified object.

Methods

_Default(Object)	Reserved for internal use.
Add(Object, XlRowCol, Object, Object, Object)	Adds one or more new series to the SeriesCollection collection.
Extend(Object, Object, Object)	Adds new data points to an existing series collection.
GetEnumerator()
Item(Object)	Returns a single object from a collection.
NewSeries()	Creates a new series. Returns a Series object that represents the new series.
Paste(XlRowCol, Object, Object, Object, Object)	Pastes data from the Clipboard into the specified series collection.

Applies to

Share via