Page 1 of 1
Y-Axis default to date and time when both are present
Posted: Fri Sep 12, 2008 9:30 am
by lkoops
If the input data looks like this:
"09/09/2008 15:44:28.609","0","0","1524674.5138825 . . .
It makes sense for the axis to be date and time.
But that's using my sense.
Posted: Fri Sep 12, 2008 11:36 am
by jsc
I made up a dummy csv file with your input line, and edited the decimal seconds to 609, 610, 611, etc. to 620.
I right-clicked the file and had DPlot open it directly.
DPlot correctly interpreted the x-axis to a 2-line date and time with just full seconds showing.
I adjusted the number format to "hh:mm:ss.000 tt" and DPlot showed the date correctly, with all the resolution.
It's all there, just need a slight adjustment.
Excel 2003 really trashed the csv file however...
Posted: Fri Sep 12, 2008 1:38 pm
by lkoops
Dplot displays the date and time across the bottom axis, but if you right click on the axis, "Calendar Date" is ticked. This affects the way some dialogs and functions work. For example, the status bar just shows the date in the coordinates as you move the cursor over the graph. You have to right click and select "Date and Time" to get the date and time in the status line and in the pop-ups.
I am suggesting that if the data contains the date and time, then the axis type should default to "Date and Time" rather than "Calendar Date"
-Luke
Posted: Fri Sep 12, 2008 4:08 pm
by DPlotAdmin
You're right, it should do that. Will fix this in the next release.
Automatically detecting data/time type for the x Axis
Posted: Tue Nov 11, 2008 10:22 am
by lkoops
Thanks for implementing my suggestion. This is to confirm that it works.