GrapeCity.Documents.Excel.Drawing.ISeriesCollection

ISeriesCollection Interface

Represents a collection of all ISeries objects in a chart.

Use this interface to access, add, and create chart series returned by SeriesCollection.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISeriesCollection : IEnumerable<ISeries>, IEnumerable

Public Interface ISeriesCollection
    Inherits IEnumerable(Of ISeries), IEnumerable

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", 20}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200);
ISeriesCollection seriesCollection = shape.Chart.SeriesCollection;
seriesCollection.Add(worksheet.Range["A1:B3"]);

Properties

Name	Description
Count	Gets the number of ISeries objects in the collection. Use this property to determine how many data series are currently contained in the parent chart.
this[int]	Gets the series at the specified index in the collection. Use this property to access an individual chart series after series have been added to the chart.
this[string]	Gets the series with the specified name from this collection. Use this indexer to retrieve a chart series by its name after series names have been assigned or inferred from the source data.
Parent	Gets the parent chart that contains this series collection. Use this property to navigate from an ISeriesCollection object back to its owning IChart.

Methods

Name	Description
Add(IRange)	Adds one or more new series to the ISeriesCollection collection. This overload automatically determines whether each series is created from rows or columns in the source range.
Add(IRange, RowCol)	Adds one or more new series to the ISeriesCollection collection. Use `rowCol` to specify whether each series is created from rows or columns in the source range.
Add(IRange, RowCol, bool, bool)	Adds one or more series to this ISeriesCollection from the specified range. Use `rowCol` to indicate whether each series is built from rows or columns in `source`. Use `seriesLabels` to indicate whether the first row or column contains series names, and use `categoryLabels` to indicate whether the first row or column contains category labels.
Extend(IRange, RowCol, bool)	Adds data points from the specified range to the existing series in this collection. Use this method to extend a chart with additional source data after the initial series have already been added. The `rowcol` parameter determines whether the new values are read by rows or by columns, and `categoryLabels` specifies whether the first row or column in `source` contains category labels. The `source` range must not be `null`. Use `rowcol` to specify whether the values are arranged by Rows or Columns. Set `categoryLabels` to `true` if the first row or column in `source` contains category labels; otherwise, set it to `false`.
NewSeries()	Creates a new series in this collection. Use the returned ISeries object to configure the newly created chart series.