time formats

Have a suggestion for improving DPlot or a question about existing features? Let us know
Post Reply
eugene
Posts: 1
Joined: Sun Feb 29, 2004 6:52 am
Location: Scotland

time formats

Post by eugene »

Is it possible to plot time in the format mm:ss.00 (including hundreths of seconds) against dates eg 12/05/2003.

I have downloaded a trial version but am not clear how, or if, this can be done presently.
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

This is a timely question... I was about to upload an update, started to answer your question and noticed a few problems with reading times from files.

Reading a file of dates and times that looks like this:

1/01/2004,12:00:00.00 AM
1/02/2004,12:00:00.20 AM
1/03/2004,12:00:00.40 AM
1/04/2004,12:00:00.60 AM

should work, but doesn't. DPlot won't correctly parse the times unless they're preceded by a date, as in

1/01/2004,1/01/2004 12:00:00.00 AM
1/02/2004,1/01/2004 12:00:00.20 AM
1/03/2004,1/01/2004 12:00:00.40 AM
1/04/2004,1/01/2004 12:00:00.60 AM

This will be fixed ASAP.

I'll also have an Excel Add-In that will handle this problem as well. If you check back late tonight (US Central time) you should see a fix.
Visualize Your Data
support@dplot.com
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

Eugene,
I believe the latest update (1.931) will do what you want. If you have date and time values in an ASCII text file:

1/1/2004,12:00:00.36 AM
1/3/2004,1:00:03.40 AM
1/4/2004,4:01:00.60 AM

etc., use file type 'D Multiple columns (2D)' to open the file. DPlot will correctly parse the dates and times (including the fractional seconds) and automatically select the appropriate number formatting for the X and Y axes.

If your dates and times are in an Excel spreadsheet, take a look at the new Add-In, which does essentially the same thing.

Please let me know if you have any questions on this.
Visualize Your Data
support@dplot.com
Post Reply