How to set Error Bars to _two_ SDs?
 

I have a spreadsheet containing means and standard deviations, and want
to create graphs showing TWO standard deviations as error bars. Working
with one SD is no problem; I just set custom Y error bars to
=DATA_SHEET!$CO$2:$CO$367 (lots of columns, one row per day of year).
But I've had zero sucess in getting two SDs to show. I have 30 columns
of SDs, so I don't want to go building another 30 computed columns if
it can be avoided.

Is there any way at all to do this through the custom Y error bar
formula alone?

Thanks

Robert Smith

Robert -

I have a web page that tells about error bars:

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

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

wrote:

I have a spreadsheet containing means and standard deviations, and want
to create graphs showing TWO standard deviations as error bars. Working
with one SD is no problem; I just set custom Y error bars to
=DATA_SHEET!$CO$2:$CO$367 (lots of columns, one row per day of year).
But I've had zero sucess in getting two SDs to show. I have 30 columns
of SDs, so I don't want to go building another 30 computed columns if
it can be avoided.

Is there any way at all to do this through the custom Y error bar
formula alone?

Thanks

Robert Smith