Podcast
Questions and Answers
For our example, these PivotTables can change rows, but not columns so we placed them on the same row with a ______ column in between each one.
For our example, these PivotTables can change rows, but not columns so we placed them on the same row with a ______ column in between each one.
blank
However, you might find that you need to place your PivotTables beneath each other if they can expand ______.
However, you might find that you need to place your PivotTables beneath each other if they can expand ______.
columns
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 ______ as values are filtered, added or removed.
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 ______ as values are filtered, added or removed.
contract
At this point you might want to give your PivotTables meaningful names, so you know what they ______.
At this point you might want to give your PivotTables meaningful names, so you know what they ______.
Excel will name them PivotTable1, PivotTable2 and so ______.
Excel will name them PivotTable1, PivotTable2 and so ______.
You can select each one, then go to PivotTable Tools > Analyze > enter a new name in the PivotTable Name ______.
You can select each one, then go to PivotTable Tools > Analyze > enter a new name in the PivotTable Name ______.
This will be important when it comes time to connect your PivotTables to Slicers and ______ controls.
This will be important when it comes time to connect your PivotTables to Slicers and ______ controls.
Click anywhere in the first PivotTable and go to PivotTable Tools > Analyze > PivotChart > select a chart type. We chose a Combo chart with Sales as a Clustered Column chart, and % Total as a Line chart plotted on the Secondary ______.
Click anywhere in the first PivotTable and go to PivotTable Tools > Analyze > PivotChart > select a chart type. We chose a Combo chart with Sales as a Clustered Column chart, and % Total as a Line chart plotted on the Secondary ______.
Select the chart, then size and format as desired from the PivotChart Tools ______.
Select the chart, then size and format as desired from the PivotChart Tools ______.
Now is a good time to rename your PivotCharts too. Go to PivotChart Tools > Analyze > enter a new name in the Chart Name ______.
Now is a good time to rename your PivotCharts too. Go to PivotChart Tools > Analyze > enter a new name in the Chart Name ______.
Flashcards
PivotTable placement
PivotTable placement
PivotTables should be placed on the same row, with a blank column in between to allow for expansion.
PivotTable expansion
PivotTable expansion
PivotTables can expand in rows, so place them beneath each other if needed.
PivotTable contraction
PivotTable contraction
PivotTables can contract when filtering, adding, or removing values.
PivotTable Naming
PivotTable Naming
Signup and view all the flashcards
PivotTable naming convention
PivotTable naming convention
Signup and view all the flashcards
PivotTable Renaming
PivotTable Renaming
Signup and view all the flashcards
Connecting PivotTables
Connecting PivotTables
Signup and view all the flashcards
PivotChart creation
PivotChart creation
Signup and view all the flashcards
PivotChart formatting
PivotChart formatting
Signup and view all the flashcards
PivotChart Renaming
PivotChart Renaming
Signup and view all the flashcards
