GrapeCity.Documents.Excel.Drawing.IErrorBar.Plus

Plus Property

Plus

Gets or sets the formula for the positive error amount when the error bar value type is Custom.

Use this property to retrieve the formula string that defines the positive custom error values for the error bar.

Declaration

string Plus { get; set; }

Property Plus As String

Examples

worksheet.Range["A1:C4"].Value = new object[,] {{"X", "Y", "Plus"}, {1, 2, 0.2}, {2, 4, 0.4}, {3, 3, 0.3}};
IChart chart = worksheet.Shapes.AddChart(ChartType.XYScatter, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
chart.SeriesCollection[0].HasErrorBars = true;
IErrorBar errorBar = chart.SeriesCollection[0].YErrorBar;
errorBar.ValueType = ErrorBarType.Custom;
errorBar.Plus = "=Sheet1!$C$2:$C$4";
string formula = errorBar.Plus;