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 ______.
Signup and view all the answers
Excel will name them PivotTable1, PivotTable2 and so ______.
Excel will name them PivotTable1, PivotTable2 and so ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
