Add Method

Add(IRange)

Adds one or more new series to the ISeriesCollection collection. Spread will determine where the values are by the size and orientation of the selected range.

Declaration

void Add(IRange source)

Sub Add(source As IRange)

Parameters

Type	Name	Description
IRange	source	The new data, a Range object.

Add(IRange, RowCol)

Adds one or more new series to the ISeriesCollection collection.

Declaration

void Add(IRange source, RowCol rowCol)

Sub Add(source As IRange, rowCol As RowCol)

Parameters

Type	Name	Description
IRange	source	The new data, a Range object.
RowCol	rowCol	Specifies whether the new values are in the rows or columns of the given range source. Can be one of the following RowCol constants: Rows or Columns.

Add(IRange, RowCol, bool, bool)

Adds one or more new series to the ISeriesCollection collection.

Declaration

void Add(IRange source, RowCol rowCol, bool seriesLabels, bool categoryLabels)

Sub Add(source As IRange, rowCol As RowCol, seriesLabels As Boolean, categoryLabels As Boolean)

Parameters

Type	Name	Description
IRange	source	The new data, either as a Range object or an array of data points.
RowCol	rowCol	Specifies whether the new values are in the rows or columns of the specified range.
bool	seriesLabels	True if the first row or column contains the name of the data series. False if the first row or column contains the first data point of the series.
bool	categoryLabels	True if the first row or column contains the name of the category labels. False if the first row or column contains the first data point of the series.