Adding different value error bars to each column of the SAME serie

[Naz]

In Excel 2003 I've made a bar graph with four columns where there are two
column per series (so there are 2 series). I want to add in a seperate value
error bar for each column. When I try doing that through the 'customs'
option, it adds an error bar of the same value for the second colum of the
same series. How can I get around that?

 

[Jon Peltier]

Put your individual error bar values into a range. When adding the error
bars, or later when formatting them, you can apply custom error bar values
from a range. Click the Custom radio button, click in the Custom (+) box,
then select the range containing the positive error bar values. Click in the
Custom (-) box and select the range containing the negative error bar
values.

All about Error Bars:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

- Jon