GrapeCity.Documents.Excel.Drawing.ISeries.Formula

Formula Property

Formula

Gets or sets the series formula in A1-style notation.

The returned formula describes the series definition by using A1-style references.

Declaration

string Formula { get; set; }

Property Formula As String

Examples

worksheet.Range["A1:B4"].Value = new object[,] {{"Month", "Sales"}, {"Jan", 12}, {"Feb", 18}, {"Mar", 15}};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
ISeries series = chart.SeriesCollection[0];
string formula = series.Formula;