Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can I show different standard deviations on each chart point. Seems pretty
worhless if I can't. WHose data ever has the same SD for each mean?? |
#2
![]() |
|||
|
|||
![]()
Are your chart points averages of individual points? If you want to
display the standard deviation of the data used to define the average on the chart, you can use the XY Chart Labeler add in by Rob Bovey. http://www.appspro.com/Utilities/ChartLabeler.htm If it were me, I'd probably create an X bar S type chart. "Fred Zack" wrote in message ... Can I show different standard deviations on each chart point. Seems pretty worhless if I can't. WHose data ever has the same SD for each mean?? |
#3
![]() |
|||
|
|||
![]()
Fred -
Suppose your X data are in column A and your Y data in column B. Put the standard deviations behind each Y value into the corresponding cell in column C. (You can also use the X standard deviations as well). Make the chart. Double click the series, and on the Y Error Bars tab, click in the Custom Plus box, then select the range of StDev values in column C, and repeat for the Custom Minus box. You could even plot different positive and negative error bar lengths. More on 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/ _______ Fred Zack wrote: Can I show different standard deviations on each chart point. Seems pretty worhless if I can't. WHose data ever has the same SD for each mean?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
can't find map button in Excel in Office Standard Edition 2003 | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |