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

  1. 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
  2. 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
    1. 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
  3. 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
    1. 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