Microsoft Office Tutorials and References
In Depth Information
Creating a Standard Slicer
Figure 16-8: The fact that you can visually see the current filter state gives slicers a unique advantage
over the Filter field.
To clear the filtering on a slicer, simply click the Clear Filter icon on the target slicer (shown in Figure 16-9).
Figure 16-9: Clearing the filters on a slicer.
When using slicers in a dashboard environment, you must do a bit of formatting to make your slicers
match the theme and layout of your dashboard. The following subsections describe a few common
formatting adjustments you can make to slicers.
Size and placement
A slicer behaves like a standard Excel shape object in that you can move it around and adjust its size
by clicking on it and dragging its position points (see Figure 16-10).
Figure 16-10: Adjust the slicer size and placement by dragging its position points.