Numbers error bars vanish with Standard Deviation

I'm learning Numbers. I click a chart I've made -> I choose Error Bars -> Positive and Negative -> Use: Standard Deviation -> all error bars disappear!! Standard Deviation of the data set should show as an error bar on every column!

With any other Use setting, it just puts in some default error bars whose value appears to be NOT the Standard Deviation, and cannot be changed. Changing the Range value does nothing.

Can someone help please?

iMac 27″ 5K, macOS 10.12

Posted on Aug 7, 2020 7:00 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 8, 2020 6:51 AM

Without first seeing your data or the chart you want, take note of what the standard deviation error bars are. Look at SGIII's post and the chart he attached. All the error bars are the same. They are the standard deviation of the entire data set (the series he charted). If I understand what you are trying to chart, you have multiple (three) Y's for each X and want the standard deviation for each X. I am assuming you are plotting all three Y points for each X as separate series. You will need a column in your table for the average and the stdev for each set of three points. You plot the average as another series (then immediately make it the top series by changing it's "order" to 1) and choose your stdev column for the custom error bars. I changed the data symbol to a + and added connection lines, too. The base chart is a scatter chart in the screenshot below.


If I am off the mark, no problem, just ignore me. I know you said you had "stress measure for the before and after of 3 repeats of my experimental condition" which might really just be a chart of three points vs the chart I did.


36 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers error bars vanish with Standard Deviation

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.