Standard deviations in Excel

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??

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" <FredZack@discussions.microsoft.com> wrote in message
news:EE1572A3-44B5-481A-AA10-3F671C47043B@microsoft.com...
> 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??

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??