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:

image

 

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:

Dons-Challenge-Answer-Mutli-year-Graph-by-Month-Data-Set.xlsx





 

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

Steve=True

 





1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here