Now, I'm no Stephen Few, but I'm pretty sure this breaks all kinds of Dashboarding best practices.

Take a look at this screenshot pulled from the Microsoft website. customers, products, or regions Quickly filter pivot tables using slicers Use dynamic dashboards using Power View to see exactly where your business stands. Slicers are huge and they take up lots of real estate. If that audience is still using Excel 2007, they get no love from Slicers. Unlike the other new functions (such as Percent of Subtotals and Repeat Item Labels), Slicers are specifically designed to be used by a reporting audience. Step 1: To open the contextual Slicer Tools Options tab in Excel Slicer Formatting, select a Slicer. Many of the new PivotTable functions such as Slicers will simply not work in Excel 2007. Step 4: Change the font size in the Font tab as desired. PivotTable Compatibility is still a major issue with Excel 2010. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.

A slicer will be created for every field that you selected. Mainly because of two reasons:ġ: No Backwards Compatibility with Excel 2007 In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK. Filter fields can only control the pivot table in which they live.įor all the advantages that Slicers provide, I personally don't think I will use them that often (if at all). Again, slicers have a unique advantage over Filter fields in that they can control the filter state of multiple pivot tables. At this point, any filter you apply to your slicer will be applied to all the connected pivot tables.

How to use slicers in excel 2007