Search for courses or lessons
Redeem a coupon
Start free trial
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 > Format > Field Buttons > Hide All
Select each of them and press the DEL key
Select the PivotChart and go to PivotChart Tools > Analyze > Field Buttons > Hide All
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
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
© 2019 GoSkills Ltd.
Skills for career advancement