it's almost what I need...
the AVG and 2016 is great, but The Min-Max should be from years 2015 to 2011
for example if:
Jan-2013 : 3K
Jan-2014 : 4k
Jan-2015 : 5k
I need to see in the max: 5k-2015
and in the min: 3k-2013
so it's another parameter that should be included somehow
That exactly what I'm looking for!
also I learned how to separate 2016 from the other years
(so far a added another column in excel, much easier the way you did it)
but there is still a problem - when I put in "detail" the max and min nothing happaned the Graph stayes the same.
any idea why? or what should I do?
Not sure about the latter.
Could you please share the workbook
and tell what're you expecting to see?