Yes!Originally Posted by Aussiebear
As I left it, the chart uses only the formula solution, so since the formulae update themselves as soon as the source data changes, the chart will update straightaway.
The formulae were not easy to put together (it's likely they're longer than they need to be; it's only what I first got to work while playing around).
The Power Queries were a lot easier to make but, at the moment, they need manually refreshing; this could be addressed with a one or two line macro.
As far as where to put the chart, well that's entirely a matter of taste!
On a separate matter, you're only looking at the max temperatures - wouldn't you prefer to see opportunities when both max and min temperatures are in range (even if you do have to tweak that range a bit if your seasonal temperatures don't allow you to apply the stuff at all)?
Reply With Quote