This will be important when it comes time to connect your PivotTables to Slicers and Timeline controls.Create PivotCharts.Click anywhere in the first PivotTable and go to PivotTable Tools Analyze PivotChart select a chart type. You can select each one, then go to PivotTable Tools Analyze enter a new name in the PivotTable Name box. Otherwise, Excel will name them PivotTable1, PivotTable2 and so on. Important: PivotTables can't overlap one another, so make sure that your design will allow enough space between them to allow for them to expand and contract as values are filtered, added or removed.At this point you might want to give your PivotTables meaningful names, so you know what they do. However, you might find that you need to place your PivotTables beneath each other if they can expand columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |