Excel Pivot Charts Flashcards
12 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 12 Excel Pivot Charts flashcards as text
What is the main difference between a PivotChart and a standard Excel chart?
Answer: A PivotChart is linked to a PivotTable and updates as fields change
PivotCharts are bound to PivotTable data and include interactive field buttons.
Which ribbon tab contains the command to insert a PivotChart?
Answer: Insert
PivotChart is in the Charts group on the Insert tab.
In the PivotChart Fields pane, fields placed in the Axis (Categories) area correspond to which PivotTable area?
Answer: Rows
Axis categories map to Row fields in the underlying PivotTable.
Which chart type is NOT available for a PivotChart?
Answer: XY Scatter
Scatter, bubble, and stock charts cannot be created as PivotCharts.
What do the gray buttons displayed on a PivotChart allow you to do?
Answer: Filter, sort, and expand fields directly on the chart
Field buttons provide interactive filtering and sorting without touching the PivotTable.
What happens to a PivotChart when the underlying PivotTable is deleted?
Answer: The chart becomes a static regular chart with the last data
Without its PivotTable, the chart converts to a standard chart with fixed data.
Which tool lets you add clickable buttons that filter both a PivotTable and its PivotChart at the same time?
Answer: Slicer
Slicers provide visual filters connected to one or more PivotTables and their charts.
To display Sales by Region as separate lines over Month on a PivotChart, where should the Region field be placed?
Answer: Legend (Series)
Each series in a chart comes from the Legend area, which maps to Columns.
Which feature adds interactive date-based filtering with a draggable time range to a PivotChart?
Answer: Timeline
A Timeline slicer filters PivotTables and PivotCharts by date periods.
New records were added to the source table of a PivotChart, but the chart has not changed. What should you do?
Answer: Click Refresh on the PivotChart Analyze tab
PivotCharts do not update until the PivotTable cache is refreshed.
Which option in PivotTable Options makes a PivotChart automatically reflect changes when the workbook is opened?
Answer: Refresh data when opening the file
This setting on the Data tab of PivotTable Options refreshes the cache at file open.
You want to show only the five best-selling products on a PivotChart. Which filter should you apply to the Product field?
Answer: Value Filter > Top 10 set to 5 items
Top 10 value filters can be adjusted to any number of items by sum of a value field.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026