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

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?

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Naz" wrote in message
...
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?