GrapeCity.Documents.Excel.Drawing.IErrorBar.Minus

Minus Property

Minus

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

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

Declaration

string Minus { get; set; }

Property Minus As String

Examples

worksheet.Range["A1:B4"].Value = new object[,] {{"X", "Y"}, {1, 2}, {2, 4}, {3, 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.Minus = "=Sheet1!$C$2:$C$4";
string formula = errorBar.Minus;