GrapeCity.Documents.Excel.Drawing.ISeriesCollection

Interface ISeriesCollection

Namespace

GrapeCity.Documents.Excel.Drawing

Assembly

GcDocs.Excel.dll

Represents a collection of all the ISeries objects in the specified chart.

public interface ISeriesCollection : IEnumerable<ISeries>, IEnumerable

Inherited Members

IEnumerable<ISeries>.GetEnumerator()

Properties

Count

Returns the number of objects in the collection.

int Count { get; }

Property Value

int

this[int]

Returns a single object from a collection.

ISeries this[int index] { get; }

Parameters

index int

The index number for the object.

Property Value

ISeries

The object at the specified index.

this[string]

Returns a single object from a collection.

ISeries this[string name] { get; }

Parameters

name string

The name for the object.

Property Value

ISeries

The series with the specified name.

Parent

Returns the parent object for the specified object.

IChart Parent { get; }

Property Value

IChart

Methods

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.

void Add(IRange source)

Parameters

source IRange

The new data, a Range object.

Add(IRange, RowCol)

Adds one or more new series to the ISeriesCollection collection.

void Add(IRange source, RowCol rowCol)

Parameters

source IRange

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.

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

Parameters

source IRange

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.

seriesLabels bool

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.

categoryLabels bool

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.

Extend(IRange, RowCol, bool)

Adds new data points to an existing series collection.

void Extend(IRange source, RowCol rowcol, bool categoryLabels)

Parameters

source IRange

The new data to be added to the ISeriesCollection object

rowcol RowCol

Specifies whether the new values are in the rows or columns of the given range source. Can be one of the RowCol constants: Rows or Columns.

categoryLabels bool

True to have the first row or column contain the name of the category labels. False to have the first row or column contain the first data point of the series.

NewSeries()

Creates a new series.

ISeries NewSeries()

Returns

ISeries

Returns the ISeries object that represents the new series.