ErrorBarsCollection.Add(ErrorBarType, ErrorBarDirection) Method

Adds a new error bar to the series.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ErrorBarsOptions Add(
    ErrorBarType barType,
    ErrorBarDirection barDirection
)

VB.NET

Function Add(
    barType As ErrorBarType,
    barDirection As ErrorBarDirection
) As ErrorBarsOptions

Parameters

Name	Type	Description
barType	ErrorBarType	An enumeration value that indicates the error bar type.
barDirection	ErrorBarDirection	An enumeration value that indicates the error bar direction.

Returns

Type	Description
ErrorBarsOptions	An object that contains options for the error bar.

Remarks

Error bars are displayed in the SpreadsheetControl only for the following chart types:

• Column Clustered
• Bar Clustered
• Area
• Line
• Line with Markers
• Stacked Line with Markers
• 100% Stacked Line with Markers
• Scatter
• Scatter with Smooth Lines and Markers
• Scatter with Smooth Lines
• Scatter with Straight Lines and Markers
• Scatter with Straight Lines

For other chart types, error bars can be accessed in code, exported in supported formats, and visualized in Microsoft Excel.

Follow the steps below to create an error bar:

1. Call the Add method to create an error bar for a chart series.

2. Specify the properties of the created ErrorBarsOptions object.

The following error bar settings are available:

ValueType

Gets or sets the value type of the error bar.

Value

Gets or sets the error value.

The following properties are in effect only for the custom value type (ErrorBarsOptions.ValueType):

Minus

Gets or sets the negative error value.

Plus

Gets or sets the positive error value.

The following properties allow you to customize the error bar’s appearance:

Outline

Specifies the bar width and dash style.

Fill

Specifies the bar color.

NoEndCap

Gets or sets whether the error bar has an end cap.

Note

Bars always run parallel to the Y axis (regardless of its orientation). The ErrorBarsOptions.BarDirection property has no effect.

The code sample below creates error bars for a line chart:

C#

using DevExpress.Spreadsheet.Charts;
//... 
using (var workbook = new Workbook()) 
{
    workbook.LoadDocument("..\\..\\workbook.xlsx");
    var worksheet = workbook.Worksheets[0];

    // Create a chart and specify its location.
    Chart chart = worksheet.Charts.Add(ChartType.LineMarker,worksheet["A1:B13"]);
    chart.TopLeftCell = worksheet.Cells["E2"];
    chart.BottomRightCell = worksheet.Cells["K14"];
    chart.Legend.Visible = false;

    // Create an error bar.
    ErrorBarsOptions errorBar = chart.Series[0].ErrorBars.Add(ErrorBarType.Both);
    // Specify the error bar settings.
    errorBar.ValueType = ErrorBarValueType.Percentage;
    errorBar.Value = 10;
    errorBar.NoEndCap = true;

    workbook.SaveDocument("..\\..\\Result.xlsx");
}

VB.NET

Imports DevExpress.Spreadsheet.Charts
'... 
Using workbook = New Workbook()
    workbook.LoadDocument("..\..\workbook.xlsx")
    Dim worksheet = workbook.Worksheets(0)

    ' Create a chart and specify its location.
    Dim chart As Chart = worksheet.Charts.Add(ChartType.LineMarker,worksheet("A1:B13"))
    chart.TopLeftCell = worksheet.Cells("E2")
    chart.BottomRightCell = worksheet.Cells("K14")
    chart.Legend.Visible = False

    ' Create an error bar.
    Dim errorBar As ErrorBarsOptions = chart.Series(0).ErrorBars.Add(ErrorBarType.Both)
    ' Specify the error bar settings.
    errorBar.ValueType = ErrorBarValueType.Percentage
    errorBar.Value = 10
    errorBar.NoEndCap = True

    workbook.SaveDocument("..\..\Result.xlsx")
End Using