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
_______
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
- 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.
