Error bars on NUMBERS. ( Apple )

pseudonomas Posted messages 18 Status Member -  
pseudonomas Posted messages 18 Status Member -
Good evening everyone.

Having switched to MAC OS, I haven't found everything yet regarding the free equivalent of Excel, namely Numbers. I have no intention of purchasing the Office pack, just to warn those who might suggest I switch back to Office.

I would like to plot a graph with error bars for each point following a scientific experiment. And I would like to set custom error bars for EACH point, meaning I want to set (for example) "±0.1" according to Y for the first point, then "±0.2" according to Y for the second point, and so on... The problem is that I only found the function that associates the SAME error bars for ALL points. However, every aspiring scientist knows that this isn't really acceptable...

If someone can enlighten me, I would be very grateful ^_^
And if it happens before tomorrow morning at 9 AM, you would make me a very happy man ^_^
Thank you in advance for your responsiveness!!

Have a good evening :-)

3 answers

tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
 
Hello,
Isn't there a "custom" option in addition to the standard options, value, percentage, difference?
0
pseudonomas Posted messages 18 Status Member
 
Hello,
Actually, I rushed you and I didn't follow up, sorry..

Here is what he is proposing attached. Knowing that whatever I do, it applies to ALL points...

Thank you for your promptness!
0
pseudonomas Posted messages 18 Status Member
 
Apparently, the photo didn't come through..

They offer for custom values either /
Positive
Negative
Positive and negative
0
tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
 
Hello,
Try it!
When "custom values" is selected, choose one of the options, positive, negative, or both, and then an input field should allow you to specify a range (like G2:G10 for example).
0
pseudonomas Posted messages 18 Status Member
 
I have already tried of course but it doesn't accept ranges of cells, it only accepts the numeric value that we want to apply to all the points...
0