Standard Deviation Plot

  • Thread starter Thread starter Sarah
  • Start date Start date
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.
 
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.
 
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.
Click to expand...

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
 
Back
Top