What to show? Thirty six charts or just one dynamic one? I created I chart which shows the choice of two parameters: cumulatives AVERAGE, MIN or MAX and months JAN through DEC. So, in this case we have thirty six sets of data we can choose from. Take your pick! I needed just one complex name: MONTH: =OFFSET(temp1!$B$2;0;MATCH(temp!$Q$2;monthnames;0)-1;temp!XER1-1705;1) The rest you can easily figure out yourself. You can download ExcelMoving.xlsx via: https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing
Blog over software als Access, Excel, SQL, Crystal Reports, Report Builder, Word, VBA, elfstedentochten en andere regionale zaken.