View previous topic :: View next topic |
Author |
Message |
eugene
Joined: 29 Feb 2004 Posts: 1 Location: Scotland
|
Posted: Sun Feb 29, 2004 7:01 am Post subject: time formats |
|
|
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. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Sun Feb 29, 2004 4:04 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Mon Mar 01, 2004 1:01 am Post subject: |
|
|
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 |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|