Hey, I am an expert in Excel templates as you would see in my work history here on freelancer. I have been highly rated for the quality work I do.
What you are looking for can be best done through a combination of macros and some conditional formatting.
I will make a template that will allow you to record the temperature, humidity etc. and then based on that data, you would be able to apply some filter (say Daily/Monthly) and a trend graph would be updated.
Do let me know if you would like me to work on this project for you and we may discuss the details.
Thanks and Regards,
Rishi
(Automyze Consulting)