Forum Discussion
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,...
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.
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