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

Similar questions

36 replies

Aug 8, 2020 5:01 PM in response to SGIII

Thanks SG, I went to that template section and found that the 'Column, stacked column, and area charts' are what I need to be using! Very helpful to know...

Badunit

Level 7

31,351 points

Aug 12, 2020 8:58 PM in response to Badunit

I still don't know what was not "permitted". Here is the image I deleted from my post to get it to post.

Aug 12, 2020 9:21 PM in response to Badunit

Re image posting problem, I think the discussions page is just glitching out intermittently....

I could hardly do anything one day, and it all worked the next...

Aug 12, 2020 9:25 PM in response to Badunit

Oh that's awesome! If I can replicate what you've done, I'll be flying!

Aug 14, 2020 7:24 AM in response to Badunit

Sure, I love a good group effort!

Yellowbox

Level 7

22,295 points

Aug 9, 2020 2:11 AM in response to diannetrussell

Hi Dianne,

Just a guess. Is this what you want to do?

Data rearranged in the "Data for graph" table.

Error bars as Fixed Value (8 for both series, as calculated in Table 1).

Regards,

Ian.

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