Plotting data vs time in NUMBERS app

[larrycruzen]

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

 

[twerppoet]

Nice.

 

[larrycruzen]

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.

 

[twerppoet]

(forehead smack)

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