Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|