Hello everyone -
Fedora 33, LabPlot 2.7.0
I have now collected the year's worth of data that I want to start plotting. In my first run I am finding that the date format is coming out all wrong, and I cannot figure out how to set it right. The attached file is a PDF showing how the graph comes out.
The exported data looks like this. I include only a few rows. The entire file is 17569 rows, which is one header row and then a row for every 30 minutes for a year. The date format is month/day/year and the time format is hour:minute:second. I am trying to graph temperature against time. And yes, the temperature line will be dang near flat. don't worry about the Abs Press column for now.
Date Time,Abs Pres,Temp
01/01/2020 00:00:00,14.3228,56.923
01/01/2020 00:30:00,14.3184,56.923
01/01/2020 01:00:00,14.3110,56.923
01/01/2020 01:30:00,14.3110,56.923
01/01/2020 02:00:00,14.3065,56.923
01/01/2020 02:30:00,14.3006,56.923
01/01/2020 03:00:00,14.2946,56.923
01/01/2020 03:30:00,14.2962,56.923
01/01/2020 04:00:00,14.2946,56.923
01/01/2020 04:30:00,14.2872,56.923
01/01/2020 05:00:00,14.2829,56.923
01/01/2020 05:30:00,14.2784,56.923
01/01/2020 06:00:00,14.2784,56.923
01/01/2020 06:30:00,14.2739,56.923
01/01/2020 07:00:00,14.2755,56.923
01/01/2020 07:30:00,14.2724,56.923
01/01/2020 08:00:00,14.2724,56.923
01/01/2020 08:30:00,14.2755,56.923
01/01/2020 09:00:00,14.2724,56.923
01/01/2020 09:30:00,14.2710,56.923
01/01/2020 10:00:00,14.2636,56.923
01/01/2020 10:30:00,14.2591,56.923
01/01/2020 11:00:00,14.2547,56.923
01/01/2020 11:30:00,14.2400,56.923
01/01/2020 12:00:00,14.2252,56.923
01/01/2020 12:30:00,14.2118,56.923
01/01/2020 13:00:00,14.2014,56.923
I create a project, then add a spreadsheet to the project. Then I import to the spreadsheet from the CSV file. In the import screen I specify the date format as "MM/dd/yyyy mm:hh:ss". LabPlot seems to completely ignore the format I give it, as evidenced by the dates on the graph. I also try changing the format in the definition of the x-axis, but it has no apparent effect. The drop-down boxes for both screens does not contain a date format that will work.
Is there a way to tell LabPlot what the format of the date string is?
Thanks!
--
Bill Gee