Error bars do not work with custom values - multiple series chart

[haddad333]

I have a bar which has multiple series. Think of it as a number charts combined together. 

I created a table which has the 8 series to be plotted.  For each series has a std deviation for each value. 

Every value is an average of a sample population and as such has a std deviation which I want to plot using error bar options of Excel. 

The bug i'm facing is that thee first series takes (plots) the custom error values while all other series show nothing. I tried the view/paint options of the error bars but that did not help.  I'm convinced the problem is either a bug or some issue with data "reading" . 

I have attached the excel. The first tab "results Graph 03" has the bars I'm talking about. 

The first graph is column chart labeled "Sorptivity summary of 3 months specimens grouped by mixture design".In that graph there are the 8 series plotted in it. Labeled in the table columns as A,B,C,D with post-fix H and F each.

For each series i added in Column O a bunch of value which are the standard deviations representing the errors.

I do not need or want to use the std deviation or other features provided by MSFT error bar options. I want to use those custom values as both the plus and the minus ones. 

Steps i use

1>  Add chart elements > Error options

2> I choose the series

3> for the series i choose "Custom" as the error amount and specifiy the + and -ve as the std deviation in column O. 

Nothing happens except for first series A-H

[#2]

@haddad333 

You need to restructure your data a bit. Let take A-F series

A-F series takes entire column marked as (1) here

Thus errors are also shall be defined for entire column, it is marked as (2) here, when it'll be shown - you have empty errors for empty values and some for non-zero ones. In your case error values were shifted on empty values and not shown together with them.

[#3]

@Sergei Baklan I added a new column still the errors bar do not show. 

Error bars are custom . 

[#4 · Accepted solution]

@haddad333 

Please check the file I attached with previous post. You need to define entire column for error values

[#5]

yes thanks !! @Sergei Baklan 

[#6]

@haddad333 , you are welcome