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.