Series Collection Methods

Name Returns Description

Add Series Method. Parameters: Source, Rowcol, [Series

Labels], [CategoryLabels], [Replace]. Adds a Series to the collection. The Source parameter specifies either a range or an array of data points describing the new series (and all the points in it). The Rowcol parameter sets whether the row or the column of the Source contains a series of points. Set SeriesLabels or CategoryLabels to True to make the first row or column of the Source contain the labels for the series and category, respectively

Extend

Variant

Method. Parameters: Source, [Rowcol], [Category-Labels] . Adds the points specified by the range or array of data points in the Source parameter to the SeriesCollection. See the Add method for details on the other parameters

Paste

Variant

Method. Parameters: Rowcol, [SeriesLabels], [CategoryLabels], [Replace], [NewSeries]. Pastes the data from the Clipboard into the Series-Collection as a new Series. See the Add method for details on the other parameters

NewSeries

Series

Method. Creates a new series and returns the newly created series

0 -1

Post a comment