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 here:

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
_______

On Apr 14, 5:44 pm, AdamV <Ad...@discussions.microsoft.com> wrote:

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.