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

  • Thread starter Thread starter Naz
  • Start date Start date
N

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?
 
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
 
Back
Top