I overlap for period so I can see all the Winter months on one worksheet. So the data for each 13-month period from 1 November one year to 30 November the next year is on its own worksheet. There's also a summary sheet showing for each month the number of occurrences of 6 or so temperature ranges. Finally I have a worksheet showing data for all years with the intent of creating a graph to show the differences year by year.
It's this latter graph that's causing me problems. By including the data for each day or each year the graph is too cluttered, but if I miss days, e.g. only use data every 2/5/7 days or whatever, I can easily miss a short spell of unusual temperatures.
Hopefully I've managed to convey my dilemma. maybe what I'm trying to achieve is unrealistic.
I've posted the spreadsheet here, the worksheet in question is All data. I'm using Excel 2010.
I'd appreciate advice, so helpful thoughts and advice would be welcome.
We have more and more laws, and less and less enforcement