GrapeCity.Documents.Excel.Drawing.ErrorBarType

ErrorBarType Enum

Specifies how the range of a chart series error bar is calculated.

Use this enum with ValueType to define whether the error bar range is based on a fixed value, a percentage, standard deviation, standard error, or custom worksheet formulas.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public enum ErrorBarType

Public Enum ErrorBarType

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Quarter", "Sales"},
    {"Q1", 1200},
    {"Q2", 1500},
    {"Q3", 1800}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
shape.Chart.SeriesCollection[0].HasErrorBars = true;
IErrorBar errorBar = shape.Chart.SeriesCollection[0].YErrorBar;
errorBar.ValueType = ErrorBarType.FixedValue;

Fields

Name	Description
Custom	Range is set by fixed values or cell values.
FixedValue	Fixed-length error bars.
Percentage	Percentage of range to be covered by the error bars.
StDev	Shows range for specified number of standard deviations.
StError	Shows standard error range.