Forum Discussion

Chris Tetley's avatar
Chris Tetley
Copper Contributor
Jul 04, 2026
Solved

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:

DateTimeTemperature_CelsiusRelative_Humidity(%)
01/07/202612:00 am20.861
01/07/202612:30 am20.761
01/07/20261:00 am20.761
01/07/20261:30 am20.661
01/07/20262:00 am20.561
01/07/20262:30 am20.561
01/07/20263:00 am20.461
01/07/20263:30 am20.461
01/07/20264:00 am20.361
01/07/20264:30 am20.361
01/07/20265:00 am20.261
01/07/20265:30 am20.260
01/07/20266:00 am20.160
01/07/20266:30 am20.160
 
  • Chris Tetley​ 

    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 Tetley's avatar
    Chris Tetley
    Copper 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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Chris Tetley​ 

    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.