In the upper-right of the timeline, click the drop-down arrow, and choose a timeframe, such as Days. In this example, there’s just one.Īdjust the size of the timeline and move it where you want. The Insert Timelines dialog has an option for each date field in your PivotTable. On the ANALYZE tab, click Insert Timeline. To add a timeline, click a cell in your PivotTable. To reset the slicers, click the Clear Filter button at the top right of each slicer. In the Store slicer, click Bellevue, press the Ctrl key, and click Seattle.Īnd in the PivotTable, you now see just the Cooking and Romance books sold in October at the Bellevue and Seattle stores. To see the Cooking and Romance books sold in October at the Bellevue and Seattle stores, in the Genre slicer, click Cooking, press the Ctrl key, and click Romance. The Insert Slicer dialog box has options for each field in the PivotTable.Ĭheck the fields you want to slice the PivotTable with, and click OK.Īdjust the size of the slicers, move them where you want, and you are ready to slice your PivotTable. To add a slicer, click a cell in your PivotTable, and the PIVOTTABLE TOOLS tab appears.Ĭlick ANALYZE, click Insert Slicer. You can use Slicers and Timelines to filter your PivotTable data, and at a glance, you can see what filters are applied. There are lot of advanced tools in Excel to help you analyze your PivotTable data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |