![]() ![]() This is the easiest way to capture slicer selection into a cell. When you want to do something like that, you essentially want the slicers to talk to your formulas. For example, you may want to use slicers to add interactivity to your charts or use them in your dashboard. While slicers are amazing & fun, often you may want to use them outside pivot table framework. Capturing slicer selection using formulas You can examine this chart in detail in the Slicer Examples workbook. You can use the same approach to link one slicer to more than one chart (pivot chart or regular one). Now both pivot tables will respond to the slicer. Right click on the slicer and go to Report Connections (in Excel 2010, this is called as PivotTable connections).This can be confusing once you have more than a few pivot tables. If you don’t name your pivot tables, Excel will give them default names like PivotTable73. ![]() To name the pivot tables, click anywhere in the pivot, go to Analyze ribbon and use the pivot table name field on top-left to give it a name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |