
Jerrold Green1 Mar 6, 2011 7:49 AM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MAlexa,
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 
Alexa M Mar 6, 2011 9:15 AM
Re: Adding Standard Deviation Bars to graphs in response to Jerrold Green1Thank 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. 
Alexa M Mar 6, 2011 11:25 AM
Re: Adding Standard Deviation Bars to graphs in response to Jerrold Green1Nevermind, I figured it out. Thank you. I'll try to not forget how to do it this time! 
Baltser Apr 19, 2011 1:39 PM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MHi!
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

Jerrold Green1 Apr 19, 2011 7:55 PM
Re: Adding Standard Deviation Bars to graphs in response to BaltserLouise,
The answer to your question is in the second post in this topic.
Jerry

Baltser Apr 19, 2011 11:05 PM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MHi 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

Jerrold Green1 Apr 20, 2011 4:45 AM
Re: Adding Standard Deviation Bars to graphs in response to BaltserLouise,
I apologize if my reply seemed abrupt. Here is a screen shot that I hope will illlustrate my explanation in the post above.
Does that help?

Jerrold Green1 Apr 20, 2011 5:31 AM
Re: Adding Standard Deviation Bars to graphs in response to Jerrold Green1Note on Screen Shot: Click on the image to enlarge it. Click on the "X" in the upper right corner to dismiss the enlargement.
Jerry

Baltser Apr 20, 2011 6:56 AM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MThank you so much  that screen shot just made my day!!

dimsum_sushi Apr 30, 2011 11:13 PM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MHi, 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?

dimsum_sushi May 1, 2011 12:09 AM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MNever 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.

laughteraddict89 May 2, 2011 11:57 AM
Re: Adding Standard Deviation Bars to graphs in response to Jerrold Green1I 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

Jerrold Green1 May 2, 2011 1:15 PM
Re: Adding Standard Deviation Bars to graphs in response to laughteraddict89Yes, you need an upgrade. It's worth it if you use charts a lot.
Jerry

williamhltdudu Aug 13, 2011 12:05 AM
Re: Adding Standard Deviation Bars to graphs in response to Alexa MI 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