Excel Slicers are easy to use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list.

You can add and use Slicers to select items to filter a PivotTable in a more visual way. If you have Excel 2010, you can use the new Slicers tool to make your PivotTable even easier to work with.

In Excel 2013, if you want to add Slicer to your charts, select the data range and click on insert > Slicer. Now, select the part of the data you want to use as a filter.

This is the demonstration file to accompany the article, How to use a custom sort on slicer buttons in Microsoft Excel, by Susan Harkins.