GrapeCity.Documents.Excel.Drawing.ErrorBarInclude

ErrorBarInclude Enum

Specifies which error-bar parts to include.

Use this enum with Type to control whether a chart series displays positive error bars, negative error bars, both, or none.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public enum ErrorBarInclude

Public Enum ErrorBarInclude

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);
ISeries series = shape.Chart.SeriesCollection[0];
series.HasErrorBars = true;
series.YErrorBar.Type = ErrorBarInclude.Both;

Fields

Name	Description
Both	Both positive and negative error range.
Minus	Only negative error range.
None	No error bar range.
Plus	Only positive error range.