Back to lesson
1. If you create a Pivot Chart against a Pivot Table, what will happen when you move fields around on the Pivot Chart?
Nothing. You must update the Pivot Chart by changing the Pivot Table.
The Pivot Chart will update and the Pivot Table will change to match it
The Pivot Chart will update and the Pivot Table stays the same
2. How do you remove the grey buttons from the PivotChart shown below?
Select the chart and go to Pivot Chart Tools -->Analyze -->Field Buttons -->Hide All
Select them and press the Delete key
Right click the chart -->Options -->Hide Filters
3. How do you link the Pivot Chart title back to a worksheet cell?
The chart title is already linked to the top left cell in the Pivot Table
Pivot Chart titles cannot be linked to cells
Select the chart title, press = and link to a cell (just like a normal chart)
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement