Hello,
Following is the code snippet to create error bars in the excel. But in the exported excel file error bars does not have Caps.
ChartSerie oSeries = xlCharts.Series.Add();
oSeries.Name = seriesname;
oSeries.CategoryLabels = xlWorkSheet.Range[listchartseries[i].XFrom.x, listchartseries[i].XFrom.y, listchartseries[i].XTo.x, listchartseries[i].XTo.y];
oSeries.Values = xlWorkSheet.Range[listchartseries[i].YFrom.x, listchartseries[i].YFrom.y, listchartseries[i].YTo.x, listchartseries[i].YTo.y];
oSeries.Format.MarkerBorderWidth = chart1.Series[i].BorderWidth;
oSeries.Format.Fill.FillType = ShapeFillType.SolidColor;
oSeries.Format.Fill.ForeColor = listchartseries[i].SeriesColor;
var eb = oSeries.ErrorBar(true, ErrorBarIncludeType.Both, ErrorBarType.StandardError);
oSeries.Format.MarkerStyle = ChartMarkerType.Square;
oSeries.Format.MarkerSize = 4;
oSeries.ErrorBarsY.HasCap = true;
eb.HasCap = true;
eb.Border.Color = listchartseries[i].SeriesColor;
eb.Border.Pattern = ChartLinePatternType.Dash;