Adding Standard Deviation Bars to graphs

Alexa,
I see you've returned to the Standard Deviation subject that you first asked about in December.
The big picture is that you have several sets of data that you have summarized. Your summary includes an average or an estimate of the mean and a standard deviation calculation for each data set.
Now you have a series (range) of cells that contains the average or mean and a series that contains the standard deviation calculations. I also assume that you have a header row or column that has your labels.
Select the range with the averages and Chart it. Select the series in the chart and in the Chart Inspector go to the Series Tab and expand the Advanced menu. Click the Error Bars tab and choose Positive and Negative. Change Fixed Value to Custom. Delete the default number in the Positive field and then click on the cell range label for the standard deviation in your table. Do the same for the Negative field.
That is the whole deal. If you have any problems, let us know.
Jerry(dead)iMac G5, 10.5.8 / iMac Core 2 Duo & MBP, 10.6.6
Like (0)


Thank you, I tried your directions, but it is still stuck on the same error bar for every column. Every time I change the cell range, it affects every column.MacBook Pro, n/a

Like (0)


Nevermind, I figured it out. Thank you. I'll try to not forget how to do it this time!MacBook Pro, n/a

Like (0)


Hi!
I have the same problem! I have two bars each of which is an average with a standard deviation. How did you add your standard deviation to each bar??
Thanks,
Louise

Like (0)


Louise,
The answer to your question is in the second post in this topic.
Jerry

Like (0)


Hi Jerry,
I know you posted, but I dont understand what you have written! I am not a computer genius and my version is in Danish, which makes it even harder to find the right functions, However, do you make a chart of the 2 averages and then click on the "i" (blue bottom in right left corner, which is Information in danish but I assume that it would be Chart Inspector in english) because that is what I do. And as Alexa wrote it still selects both bars at the same time, it is impossible only to select one at at time!
Thank you for you quick reply
Louise

Like (0)



Note on Screen Shot: Click on the image to enlarge it. Click on the "X" in the upper right corner to dismiss the enlargement.
Jerry

Like (0)


Thank you so much  that screen shot just made my day!!

Like (0)


Hi, I'm having the same problem as is described by the original poster and am in serious need of help!
However, I don't have anything which looks like the Chart Inspector which is posted by Jerrold Green1 above. I am using Microsoft Excel 2008 for Mac, Version 12.2.9. Where do I find the Chart Inspector?

Like (0)


Never mind! I just switched my spreadsheet to Numbers, and now it all makes sense...! Thanks for your previous postthe screenshot in particular was really helpful.

Like (0)


I am trying to add error bars to a graph too. However when I follow these steps...
"Select the range with the averages and Chart it. Select the series in the chart and in the Chart Inspector go to the Series Tab and expand the Advanced menu."
There is no option to expand to the advanced menu. I have Numbers 08' is this function not available?
Thanks

Like (0)


Yes, you need an upgrade. It's worth it if you use charts a lot.
Jerry

Like (0)


I know this question has been asked a long time ago... I am actually facing this problem.. But I thinking I have found another easier solution..
in the positive value: first enter the std error or std dev value, follow by comma, space then enter the std error or std value for the second bar. Now you have different std error/dev value for different column
do the same thing for the negative value....
Cheers

Like (0)
