Yeah, 2007 makes it harder. Select the series, go to the middle of the three
chart contextual tabs, find the error bars button, drop it down, choose the
little item at the very bottom (not one of the four lame options which are
visible). In the dialog, select the custom radio button, then click on the
button that becomes enabled, and select your range(s).

Did I say ranges? The best thing to do is calculate your error bar values in
the worksheet, and use these as the source data for the custom error bars.

I'm working on an article actually on Excel 2007 error bars, which should be
posted to my blog tomorrow. Assuming it is finished on time, it will be
posted at:

http://peltiertech.com/WordPress/200...in-excel-2007/

It will include a small free utility that makes error bars just a little bit
easier in Excel 2003 and a whole lot easier in 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Helen" wrote in message
...
Thanks, but I'm using 2007. Sorry I forgot to say that! If I'm right, the
explanation given works on earlier versions but not 2007. Wish I'd bought
an
older version now!

Helen

"Shane Devenshire" wrote:

Hi,

You did not say what version of Excel you are using -

Select the series and choose Format, Selected Data Series, Y - Error
Bars,
choose the Standard Deviation option. Repeat for the other series.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Helen" wrote:

I have two sets of data, and have used the mean to make a column chart.
I now
need to add standard deviation error bars, which will be different for
each
mean. The only way I have seen to do this so far is by switching the
data
over the axis (ie, clicking "Switch row/column") but this clumps my
bars
together and gets rid of the axis labels for the two columns.

Is there a way to get different error bars without doing this?