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