'Declaration
 
Overloads Function Add( _
   ByVal source As WorksheetReference, _
   Optional ByVal plotBy As Nullable(Of RowCol), _
   Optional ByVal seriesLabels As Nullable(Of Boolean), _
   Optional ByVal categoryLabels As Nullable(Of Boolean), _
   Optional ByVal replace As Boolean _
) As ISeries

'Usage
 
Dim instance As ISeriesCollection
Dim source As WorksheetReference
Dim plotBy As Nullable(Of RowCol)
Dim seriesLabels As Nullable(Of Boolean)
Dim categoryLabels As Nullable(Of Boolean)
Dim replace As Boolean
Dim value As ISeries
 
value = instance.Add(source, plotBy, seriesLabels, categoryLabels, replace)

ISeries Add( 
   WorksheetReference source,
   Nullable<RowCol> plotBy,
   Nullable<bool> seriesLabels,
   Nullable<bool> categoryLabels,
   bool replace
)

Parameters

source

The new data as an GrapeCity.Spreadsheet.IRange object.

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.

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.

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.

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.

Reference

ISeriesCollection Interface
ISeriesCollection Members
Overload List