Hi,
I have the following data from my thermo datalogger: Column A: date Column B: Time Column C: temperature
For example:
2015-06-12 11:00:02 23,1
2015-06-12 12:00:02 23,2
2015-06-12 13:00:02 23,3
2015-06-12 14:00:02 23,4
2015-06-12 15:00:02 23,6
2015-06-12 16:00:02 23,8
2015-06-12 17:00:02 24,1
I can make a nice line graph, but unfortunately I cannot arrange nice labels on the X axis. Or I get all the the more than 400 hourly samples as a label, or I get the dates, but then I end up with a bar graph which shows the maximum temperature.
What I would like to get is on the X axis every day and in between 2 (or more) grid lines, so that I can have an idea what the temperature at noon is, but I should not loose the hourly samples in between. Unfortunately scaling does not allow to go per hour; the minimum is per day.
Thanks a lot for your help,
Greg