Podcast Beta
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.
blank
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.
contract
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 ______.
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers