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 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.
Select each of them and press the DEL key.
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 unless you explicitly modify the PivotChart to add the data.
It is immediately updated to include the new series.
Nothing immediately. The data is added to the PivotChart the next time the PivotTable is refreshed.
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 used in the dashboard.
All PivotCharts must be built against the same PivotTable to keep them in sync.
Add slicers for filtering, and link them to each PivotTable and PivotChart used in the dashboard.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement