Plotting very small numbers in Numbers

Discussion in 'Mac Apps and Mac App Store' started by tnsmart, Aug 26, 2012.

  1. tnsmart macrumors 6502

    Joined:
    Aug 23, 2008
    #1
    I am trying to plot numbers ranging from 0.903e-19 to 2.16e-19 on the y-axis of a line graph in Numbers, but am having trouble. I can set the Max for the y-axis to 2.2e-15, but once I change it to 2.2e-16 or 2.2e-19, all of the values on my y-axis except for 0 disappear.

    Can anybody help me with this?
    I've attached the file I'm working with.
     

    Attached Files:

  2. tnsmart thread starter macrumors 6502

    Joined:
    Aug 23, 2008
    #2
    Does anybody know how to do this? Could it be a bug in Numbers? I haven't been able to create the graph in Microsoft Excel either.

    Does anybody know of a program that could graph this data?

    Any help is greatly appreciated.
    Thanks.
     
  3. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #3
    Your problem is not Numbers or the methods by which it does graphs. Your problem is that you do not have a clue as to how to enter data into a spreadsheet nor how to do scientific notation on a computer.

    I have redone your spreadsheet with everything entered properly. Study it well.
     

    Attached Files:

Share This Page