Plotting data vs time in NUMBERS app

Discussion in 'iPad General Discussions' started by larrycruzen, Sep 8, 2014.

  1. larrycruzen

    larrycruzen
    Expand Collapse
    iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    83
    Thanks Received:
    12
    I finally figured out how to plot data vs random times of day in NUMBERS.

    I record the time using the "now" button, which will produce hours & minutes, such as 8:36 PM. It is necessary to insert an adjacent column and convert these times to hours in 24 hour decimal format (20.6 hrs). This is easy to do using "HOUR"+"MIN"/60 functions.

    The data will plot properly on a scatter plot.

    Larry Cruzen
     
  2. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,422
    Thanks Received:
    6,103
  3. larrycruzen

    larrycruzen
    Expand Collapse
    iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    83
    Thanks Received:
    12
    Major correction to my previous post:

    All of that conversion of times is unnecessary!

    Problem was that I had the times of day in a header column. If they are in a body column, they plot fine on a scatter plot, even in AM/PM format . Apparently, data in a header column always plot in equal increments on the X axis.
     
    • Informative Informative x 1
    • List
  4. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,422
    Thanks Received:
    6,103
    (forehead smack)

    Now why didn't that occur to me. I put the date-time in the header too, pretty much out of habit.
     

Share This Page