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.
Y-Axis default to date and time when both are present
Moderator: DPlotAdmin
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...
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...
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
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
- DPlotAdmin
- Posts: 2312
- Joined: Tue Jun 24, 2003 9:34 pm
- Location: Vicksburg, Mississippi
- Contact:
You're right, it should do that. Will fix this in the next release.
Visualize Your Data
support@dplot.com
support@dplot.com
Automatically detecting data/time type for the x Axis
Thanks for implementing my suggestion. This is to confirm that it works.