Back to lesson
1. You have the following PivotChart, and would rather use slicers than the ugly filter buttons. How would you remove the filter buttons?
Select each of them and press the DEL key.
Select the PivotChart and go to PivotChart Tools > Analyze > Field Buttons > Hide All.
Select the PivotChart and go to PivotChart Tools > Format > Field Buttons > Hide All.
2. You create a nice PivotTable, and then create a PivotChart based on that PivotTable. After spending a long time getting the formatting customized to be just right, you send it off to a user. That users adds a new field to the PivotTable Values area. What happens to the PivotChart you worked so hard on?
Nothing immediately. The data is added to the PivotChart the next time the PivotTable is refreshed.
Nothing unless you explicitly modify the PivotChart to add the data.
It is immediately updated to include the new series.
3. When building a dashboard that uses multiple PivotTables and PivotCharts, what do you need to do to keep them all in sync?
Add slicers for filtering, and link them to each PivotTable and PivotChart used in the dashboard.
Add slicers for filtering, and link them to each PivotTable used in the dashboard.
All PivotCharts must be built against the same PivotTable to keep them in sync.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement