How To Create 12 Month Calendar Dashboard Showing Action Items

[Blade]

Sheet1 has Date, Dept, Action Item

What is the best way to create a dashboard with a 12 month view, that filters items from Sheet1, dependent on user selection (Date and Dept)?

 

[AlanSidman]

You might want to start here https://excelcharts.com/excel-dashboards-charley-exceluser-kyd/ since you provided no specifics or raw data about what your workbooks look like.

 

[GraH - Guido]

It largely is depending on your level of knowledge of Excel. The best solution might be the one you actually master.
I always suggest starting with simple slicers on pivot tables/charts. Then see how far this brings you.
Look at the dashboard challenges on the -blog. Heaps to learn from, inspiring stuff by many contesters.
I find that Chandeep over at goodly.co.in brings the use of slicers to an all other level. He has a tutorial in which he creates a dashboard like that in 15 minutes.