GrapeCity.Spreadsheet.Charts.ISeriesCollection.Add

Add Method

Add(IRange, RowCol?, bool?, bool?, bool)

Adds one or more new series to the ISeriesCollection collection.

Declaration

ISeries Add(IRange source, RowCol? plotBy = null, bool? seriesLabels = null, bool? categoryLabels = null, bool replace = false)

Function Add(source As IRange, Optional plotBy As RowCol? = Nothing, Optional seriesLabels As Boolean? = Nothing, Optional categoryLabels As Boolean? = Nothing, Optional replace As Boolean = False) As ISeries

Parameters

Type	Name	Description
IRange	source	The new data as an IRange object.
RowCol?	plotBy	Specifies whether the new values are in the rows or columns of the specified range. If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.
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. If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.
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. If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.
bool	replace	If `categoryLabels` is `true` and `replace` is `false`, the specified categories replace the categories that currently exist for the series. If `replace` is `false`, the existing categories will not be replaced.

Returns

Type	Description
ISeries	An ISeries object that represents the new series.

Add(string, RowCol?, bool?, bool?, bool)

Adds one or more new series to the ISeriesCollection collection.

Declaration

ISeries Add(string source, RowCol? plotBy = null, bool? seriesLabels = null, bool? categoryLabels = null, bool replace = false)

Function Add(source As String, Optional plotBy As RowCol? = Nothing, Optional seriesLabels As Boolean? = Nothing, Optional categoryLabels As Boolean? = Nothing, Optional replace As Boolean = False) As ISeries

Parameters

Type	Name	Description
string	source	The new data as an IRange object.
RowCol?	plotBy	Specifies whether the new values are in the rows or columns of the specified range. If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.
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. If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.
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. If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.
bool	replace	If `categoryLabels` is `true` and `replace` is `false`, the specified categories replace the categories that currently exist for the series. If `replace` is `false`, the existing categories will not be replaced.

Returns

Type	Description
ISeries	An ISeries object that represents the new series.

Add(WorksheetReference, RowCol?, bool?, bool?, bool)

Adds one or more new series to the ISeriesCollection collection.

Declaration

ISeries Add(WorksheetReference source, RowCol? plotBy = null, bool? seriesLabels = null, bool? categoryLabels = null, bool replace = false)

Function Add(source As WorksheetReference, Optional plotBy As RowCol? = Nothing, Optional seriesLabels As Boolean? = Nothing, Optional categoryLabels As Boolean? = Nothing, Optional replace As Boolean = False) As ISeries

Parameters

Type	Name	Description
WorksheetReference	source	The new data as an IRange object.
RowCol?	plotBy	Specifies whether the new values are in the rows or columns of the specified range. If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.
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. If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.
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. If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.
bool	replace	If `categoryLabels` is `true` and `replace` is `false`, the specified categories replace the categories that currently exist for the series. If `replace` is `false`, the existing categories will not be replaced.

Returns

Type	Description
ISeries	An ISeries object that represents the new series.