GrapeCity.Documents.Excel.Drawing.IChartTitle.FormulaR1C1

FormulaR1C1 Property

FormulaR1C1

Gets or sets the formula of the chart title using R1C1-style notation, in English.

Declaration

string FormulaR1C1 { get; set; }

Property FormulaR1C1 As String

Examples

worksheet.Range["E1"].Value = "Sales Analysis";
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.HasTitle = true;
chart.ChartTitle.FormulaR1C1 = "=Sheet1!R1C5";
string formula = chart.ChartTitle.FormulaR1C1;