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:

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

Steve=True

Stay Connected!