adding confidence intervals to the bar chart

Hello,
could you please help to solve the problem concerning adding line segments, which represent confidence intervals (values in the columns 'X-s' and 'X+s'), to the bar chart, as shown in the attached example. The top ends of the bars indicate observation means.

Thank you.

Best wishes,
Malgosia

You mean something like this (see attached)?

Originally Posted by XOR LX

You mean something like this (see attached)?

Yes, it is ok. I have just added line segments, that join minimum and maximum values (values in the columns 'X+s' and 'X-s').

Thank you for your help

Best wishes,
Malgosia

Originally Posted by Andy Pope

Any reason why you do not use the built in error bars, which are designed for this purpose?

In you data set you will need to recalculate the +/- X values to use to be an offset from X value rather than absolute X value.

Could you please show me how to use 'built in error bars' in the attached Excel worksheet?
I send you also my proposal for visualisation of these data.

Tahnk you for help.
Best wishes,
Malgosia

Originally Posted by Andy Pope

example includes screen shots of Error bar dialog and Custom setting dialog.

It looks much better.

Thank you very much