Standard Deviation Plot

S

Sarah

I am trying to add standard deviation bars to a series of data points on
a graph in Excel. Kind of like error bars (I've found the error bar menu)
only instead of a standard error plot, using the standard deviations I've
calculated for each data set. In Excel v.X you can only select one
number for an entire series of data for its standard deviation...I am
looking for a way for each point in my data series to have its own
standard deviation on the graph. Please help! Thanks.
 
B

Bernard V Liengme

Hi Sarah,
Look at the error bar menu again. Near bottom find Custom. The boxes thee
are for the series of data for the + and the - error bar values.
Bernard

I am trying to add standard deviation bars to a series of data points on
a graph in Excel. Kind of like error bars (I've found the error bar menu)
only instead of a standard error plot, using the standard deviations I've
calculated for each data set. In Excel v.X you can only select one
number for an entire series of data for its standard deviation...I am
looking for a way for each point in my data series to have its own
standard deviation on the graph. Please help! Thanks.
 
D

dvt

Sarah said:
I am trying to add standard deviation bars to a series of data points
on a graph in Excel. Kind of like error bars (I've found the error
bar menu) only instead of a standard error plot, using the standard
deviations I've calculated for each data set. In Excel v.X you can
only select one number for an entire series of data for its standard
deviation...I am looking for a way for each point in my data series
to have its own standard deviation on the graph. Please help!
Thanks.

When I look at the "Y Error Bars" tab in Excel 2002, I see a box labeled
"Custom" that allows you to select a range of data for the positive and
negative error bars. You should be able to use that to solve your problem.

Dave
dvt at psu dot edu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top