Plotting dates and times

February 12th, 2007

I’ve just pushed an update to the server that lets you plot dates and times. You’ll notice a few changes. First, each datacolumn has a ‘type’. Plotomatic does its best to detect the type of data that you are entering. The data types supported are numbers, times, dates and date/times. If you float your mouse over the type, you can set the type or ask Plotomatic to re-detect the data type.

There are some constraints on how you use this. You can’t, for example, plot date and numeric data on the same axis. Plotomatic will complain if you try. Also, I tried to detect as many date/time formats as I could, but you may have to experiment a bit before getting it right. Here’s a list of the formats supported:
Numeric
Integers 1, 45034 and -32
Decimal numbers 1.3, -45232.323 and 0.00023
Exponential notation 1.3E23, -0.33E-32
Dates
yyyy/mm/dd or yyyy-mm-dd    1999/03/21, 1945-11-23
dd/mm/yyyy or dd-mm-yyyy 21/03/1999, 23-11-1945
mmm dd, yyyy Mar 14, 1945 or February 12, 1999
Times
hh:mm 12:23, 9:45 AM, 3:30 PM
hh:mm:ss 12:23:54, 9:45:32 AM
Date/Time
Any combination of the Date and Time formats above

Give it a shot and let me know what you think.

Sorry, comments are closed for this article.