Forum Discussion
Chart from Date, Time, Temperature and Humidity
I have data from a temperature sensor that I want to create a chart from.
The data is: Date,Time,Temperature_Celsius,Relative_Humidity(%), and it arrives as a .csv file.
If it's just a single date, then I can easily produce a line chart by ignoring the date column.
However the data will likely be for several days at a time.
So how do I create a line chart with the date and time as one value on the x-axis? If I can do that, the values on the y-axis will not be a problem.
I think it could be done by combining data and time into a single value, but I can't find how to do that, and then format the x-axis so it shows each day separately with the times as minor values.
Here's some of the data:
| Date | Time | Temperature_Celsius | Relative_Humidity(%) |
| 01/07/2026 | 12:00 am | 20.8 | 61 |
| 01/07/2026 | 12:30 am | 20.7 | 61 |
| 01/07/2026 | 1:00 am | 20.7 | 61 |
| 01/07/2026 | 1:30 am | 20.6 | 61 |
| 01/07/2026 | 2:00 am | 20.5 | 61 |
| 01/07/2026 | 2:30 am | 20.5 | 61 |
| 01/07/2026 | 3:00 am | 20.4 | 61 |
| 01/07/2026 | 3:30 am | 20.4 | 61 |
| 01/07/2026 | 4:00 am | 20.3 | 61 |
| 01/07/2026 | 4:30 am | 20.3 | 61 |
| 01/07/2026 | 5:00 am | 20.2 | 61 |
| 01/07/2026 | 5:30 am | 20.2 | 60 |
| 01/07/2026 | 6:00 am | 20.1 | 60 |
| 01/07/2026 | 6:30 am | 20.1 | 60 |
Simplest would be to create a pivot chart. See attached.
I used a combo chart. Temp as columns and humidity as a line on the 2nd y-axis.
Edit: The system is screwing up the attachment. Then I see and then it disappears. And then it's there three times. don't know why.
2 Replies
- Chris TetleyCopper Contributor
Riny,
Thanks very much for this. The spreadsheet is visible to me. Over 20 years ago I regularly used Pivot Tables, but I haven't touched them for a long, long time. I must be getting old.
Very elegant things!
Best wishes,
Chris
- Riny_van_EekelenPlatinum Contributor
Simplest would be to create a pivot chart. See attached.
I used a combo chart. Temp as columns and humidity as a line on the 2nd y-axis.
Edit: The system is screwing up the attachment. Then I see and then it disappears. And then it's there three times. don't know why.