GrapeCity.Documents.Excel.Drawing.IChartGroup.SeriesCollection

SeriesCollection Property

SeriesCollection

Gets the collection of all series in the chart or chart group.

Use the returned list to access the ISeries objects that belong to the current chart group.

Declaration

IEnumerable<ISeries> SeriesCollection { get; }

ReadOnly Property SeriesCollection As IEnumerable(Of ISeries)

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Month", "Sales", "Target"},
    {"Jan", 10, 12},
    {"Feb", 20, 18},
    {"Mar", 15, 16}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["B1:C4"]);
chart.SeriesCollection[1].ChartType = ChartType.Line;
IChartGroup chartGroup = chart.ChartGroups[0];
IEnumerable<ISeries> seriesCollection = chartGroup.SeriesCollection;