You don't need to make separate series. If each point you plot is an average
of a set of numbers and you also have the corresponding standard deviation
values in a parallel range, you can add the standard deviation values as
custom error bars. I show how to do this in Excel 2003 he

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

It's somewhat more tortuous to accomplish this in 2007, because of the
unexpected changes they've made to the user interface. I don't have 2007
handy right now, but I think you add error bars from the middle chart tools
contextual tab, then you have to delete the X error bars, and customize the
values of the Y error bars.

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


wrote in message
...
On Apr 14, 5:44 pm, AdamV wrote:
It sounds like you need to do this:
Select the series you want to show the deviation for
Go to the Chart tools Layout Ribbon
Choose "Error Bars" drop-down list (in the Analysis group near the right
hand end)
choose the type of bars you need, or go for more options



" wrote:
I am trying to enter standard deviation into my bar chart but have no
clue how to. I have ecel 2007. can anyone help and give me a broken
down version! Hellllllp!- Hide quoted text -

- Show quoted text -

Cheers Adam, Ive managed to work it out. I am stucj or something else
if you could help. I need to make the them seperate series, so that I
can enter different standard deviations on the chart. How do i lay out
my results so that I can get different series.