Search code examples
c#epplus

Epplus Error bars on charts

Using Epplus, is there a way to add error bars onto a chart series?

I haven't found any mention of Epplus being able to handle error bars anywhere and there doesn't seem to any property or method in either the chart or any individual series that indicates you can access/create error bars.

I'm trying to recreate this chart, of which all I have left are the error bars:

enter image description here

Solution

  • I didn't find any way of adding error bars using Epplus, so instead I just opened the file up in the normal interop and added them through that:

    Excel.Application app = new Excel.Application();
Excel.Workbook workbook = app.Workbooks.Open(filename);
Excel.Worksheet sheet = workbook.Worksheets[1];

Excel.Chart graph = sheet.ChartObjects("Per Employee Average (Run)").Chart;
Excel.Series series = graph.SeriesCollection("Employee Average");
Excel.Range range = sheet.get_Range(Range.Column(cRange.BackStdDev) + 2 + ":" + Range.Column(cRange.BackStdDev) + Range.Row(rRange.RunBackEnd));
series.ErrorBar(Excel.XlErrorBarDirection.xlX, Excel.XlErrorBarInclude.xlErrorBarIncludeBoth, Excel.XlErrorBarType.xlErrorBarTypeCustom, range, range);