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