adding multiple error bars to bar chart

[Guest]

i need some help!! i need to add error bars to a bar chart, and each value in
the series has a different standard error which has to be added. any ideas
how i can do this?? each time i try and change the error bar they all change
in the series!
Help me please!

 

[Andy Pope]

Hi,

On the Error bar dialog is the option to use a range as the values.
This can be used for both positive and negative values.

See Jon Peltier's page,
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

Cheers
Andy