• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How To Create 12 Month Calendar Dashboard Showing Action Items


New Member
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)?

GraH - Guido

Well-Known Member
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 :awesome:-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.