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?