Thank you Riny
Okay I've come up with this solution after some gentle persuasion from Mynda. In the workbook attached I can now chart temps and humidity with a pref...
Uhoh.... dont tell Mynda but, I've just found a Blog by her on this very subject matter. Perhaps I'll get it done before she orders me straight to t...
Thank you Riny. Late this afternoon, i came across the concept of target and actual charts, and was wondering if that could be what I am also chasin...
Thank you for your reply. Unfortunately I am unable to open either the xls file you initially posted nor the second one. They open up like 10 Shakes...
That is true, but I also asked if it were possible to make it a variable number of months as well. All that aside, thank you for taking the time to a...
Riny, your solution works well providing I don't go past 12 months. If I used a figure greater than 12 for the value in B5 then it starts to double u...
Riny, go easy on me please.....
Thank you Mynda. I found this one as well (as if I ever needed more confusion in my life). =LET(start,EOMONTH(TODAY(), -1) +1,months,B5,n,B11,dow...