Excel 2010 introduced Slicers, which you can use to filter PivotTable and PivotChart objects. A Slicer displays a set of buttons, instead of a dropdown, that you click to quickly filter the data ...

This file demonstrates the techniques explained in the article Create a quick and effective dashboard using Excel’s PivotChart and Slicer objects.