They remain connected to your table and let you filter the chart dynamically. Slicers are helpful when you frequently deal with large datasets. Open your Excel workbook and select Slicer at the top.