SeriesCollection Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Methods

Name

Description

Add

Adds one or more new series to the SeriesCollection collection.

Extend

Adds new data points to an existing series collection.

Item

Returns a single object from a collection.

NewSeries

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

Paste

Pastes data from the Clipboard into the specified series collection.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Count

Returns a Long value that represents the number of objects in the collection.

Creator

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

Parent

Returns the parent object for the specified object. Read-only.