vrijdag 6 maart 2015

Excel: Which Data In Your Graph? Take your Pick: Combine Month, Moving Average, Maximum or Minimum

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.

Een reactie posten