How to set error bar for Excel chart in C#, VB.NET?
This article explains how to set Error Bar in chart using XlsIO.
What are Error Bars?
Error bars express potential error amounts that are graphically relative to each data point or data marker in a data series. This can be achieved in XlsIO, using HasErrorBarsX and HasErrorBarsY properties in chart series.
Code snippet to set Error Bar
//Set error bar chart.Series[0].HasErrorBarsY = true; chart.Series[0].ErrorBarsY.Type = ExcelErrorBarType.Percentage;
Notes:
1. Horizontal error bars (ErrorBarsX) are applicable for 2D bar charts.
2. Vertical error bars (ErrorBarsY) are applicable for 2D line charts, 2D column charts, 2D area charts and stock charts.
3. Scatter charts and bubble charts (both 2D and 3D) do support horizontal error bars and vertical error bars.
4. Error bar type can be selected using Type property.
To know more about creating charts with various settings using XlsIO, please refer the documentation.
The following C#/ VB.NET complete code snippet shows how to set error bar in chart using XlsIO.
C#
using Syncfusion.XlsIO; using System.Reflection; using System.IO; namespace ChartSample { class Program { static void Main(string[] args) { using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2016; //Open existing workbook with data entered Assembly assembly = typeof(Program).GetTypeInfo().Assembly; Stream fileStream = assembly.GetManifestResourceStream("ChartSample.InputTemplate.xlsx"); IWorkbook workbook = application.Workbooks.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; //Initialize chart and assign data IChartShape chart = worksheet.Charts.Add(); chart.ChartType = ExcelChartType.Column_Clustered; //Assign data chart.DataRange = worksheet["A1:D6"]; chart.IsSeriesInRows = false; //Apply chart elements //Set chart title chart.ChartTitle = "Clustered Column Chart"; //Set error bars chart.Series[0].HasErrorBarsY = true; chart.Series[1].HasErrorBarsY = true; chart.Series[2].HasErrorBarsY = true; chart.Series[0].ErrorBarsY.Type = ExcelErrorBarType.Percentage; chart.Series[1].ErrorBarsY.Type = ExcelErrorBarType.Percentage; chart.Series[2].ErrorBarsY.Type = ExcelErrorBarType.Percentage; //Positioning the chart in the worksheet chart.TopRow = 8; chart.LeftColumn = 1; chart.BottomRow = 23; chart.RightColumn = 8; //Saving the workbook Stream stream = File.Create("Output.xlsx"); workbook.SaveAs(stream); } } } }
VB
Imports Syncfusion.XlsIO Imports System.Reflection Imports System.IO Namespace ChartSample Class Program Public Shared Sub Main(ByVal args() As String) Using excelEngine As ExcelEngine = New ExcelEngine Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2016 'Open existing workbook with data entered Dim assembly As Assembly = GetType(Program).GetTypeInfo.Assembly Dim fileStream As Stream = assembly.GetManifestResourceStream("ChartSample.InputTemplate.xlsx") Dim workbook As IWorkbook = application.Workbooks.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Initialize chart and assign data Dim chart As IChartShape = worksheet.Charts.Add chart.ChartType = ExcelChartType.Column_Clustered 'Assign data chart.DataRange = worksheet("A1:D6") chart.IsSeriesInRows = False 'Apply chart elements 'Set chart title chart.ChartTitle = "Clustered Column Chart" 'Set error bars chart.Series(0).HasErrorBarsY = True chart.Series(1).HasErrorBarsY = True chart.Series(2).HasErrorBarsY = True chart.Series(0).ErrorBarsY.Type = ExcelErrorBarType.Percentage chart.Series(1).ErrorBarsY.Type = ExcelErrorBarType.Percentage chart.Series(2).ErrorBarsY.Type = ExcelErrorBarType.Percentage 'Positioning the chart in the worksheet chart.TopRow = 8 chart.LeftColumn = 1 chart.BottomRow = 23 chart.RightColumn = 8 'Saving the workbook Dim stream As Stream = File.Create("Output.xlsx") workbook.SaveAs(stream) End Using End Sub End Class End Namespace
Error bar set using XlsIO