Is there a way to create a chart that shows the max, min and average temperature each day based on a single column of data? I want to create a chart based on the attached data set to show red lines for temperature and blue lines for humidity. I also attached an example to show the general idea of how it could look. The example only shows temperature, but I also want it to include lines for humidity also. Can anyone help me out?
I like to use Pivot Charts.
These are pivot tables but shown in a visually way. This way they can add Min, MAX, and average quickly.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Use a pivot table to sort the data
And then make a grafic of these data.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thank you so much for the help. I have it all set up perfectly now. You are awesome!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks