Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month.
You can read more about the original challenge here:
Also, you can see and download the other samples here:
My solution to the challenge would be to create 2 charts:
1) A Excel graph that uses a picklist to displays all or highlights just one data series with the data grouped by years with in each month.
2) A Excel chart that uses a picklist to displays all or highlights just one data series with the data grouped by month for all years.
This is a very involved chart creation and so you want to check out how I did it here:
You can download the Free sample file here:
Let me know if you like this chart and if you can use it in your next Excel dashboard.