GrapeCity.Documents.Excel.Drawing.ISeriesCollection.NewSeries

NewSeries Method

NewSeries()

Creates a new series in this collection.

Use the returned ISeries object to configure the newly created chart series.

Declaration

ISeries NewSeries()

Function NewSeries() As ISeries

Returns

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

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Q1", 10},
    {"Q2", 20},
    {"Q3", 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
ISeries series = chart.SeriesCollection.NewSeries();
series.Formula = "=SERIES(\"Sales\",,Sheet1!$B$1:$B$3,1)";