![]() Say that you build four small pivot tables and arrange them at the top of a worksheet. The real benefit of slicers is far more subtle. Sure, slicers look better than the old Page Field in Excel 2003 or the Report Filter Field in Excel 2007, but they are providing the same functionality introduced in the Report Filter Field in Excel 2007. You've had ways to filter pivot tables before. ![]() ![]() If you select Southeast from the Region slicer, the State slicer will instantly rearrange, with the southeastern states at the top of the list and the other states essentially grayed out at the bottom of the list. One slicer will respond to changes in another slicer. Since the default size of a slicer entry is taller than a typical cell in Excel, the slicer array will take up more than 5 rows above the pivot table. If the State slicer has 50 entries, you will find yourself arranging them in perhaps 2 columns of 25 rows along the side or in 5 rows of 10 columns along the top. Say that you had three slicers, one for product line, one for region, and one for State. Slicers can take up a lot of space in the Excel window. When the consumer open the workbook in Excel 2010 or on the SkyDrive, they can select values from the slicer and automatically have the pivot table update. The designer of the pivot table can arrange these lists above or to the left of the pivot table. In typical fashion, the most valuable setting for slicers is buried where most users will never find it.Ī slicer could be a list of regions, product lines, months, quarters, years, and so on. One of the new features in Excel 2010 is a type of visual pivot table filter called a Slicer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |