Friday Challenge Answer – Using Excel Slicers to Create Dynamic Charts

A big thanks to Don for submitting the first response to last week’s Friday Challenge.


You can check out the challenge here:

Friday Challenge – Excel Mutli-year Graph by Month


Don submitted this dynamic chart where a user can select their chart filter’s using slicers.


Here is a sample of what the charts look like:



Here is how Don added slicers to his charts:

1) Made the Data a Table from the Insert ribbon

2) Created Column Chart from the Data Table

3) Inserted Slicers from the Insert Menu after highlighting the data table.

Here is a quick video showing you how Don added slicers to his charts:

You can download Don’s final spreadsheet here:



Thanks Don.  I think this will really help the user Slice and Dice their data Smile



If you found the website and tutorials helpful, please consider donating to keep the lights on.

Donate with PayPal here:



Please enter your comment!
Please enter your name here