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

belinda001 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info