← All Microsoft Excel Flashcard Decks

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
  1. 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.

  2. Which ribbon tab contains the command to insert a PivotChart?

    Answer: Insert

    PivotChart is in the Charts group on the Insert tab.

  3. 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.

  4. Which chart type is NOT available for a PivotChart?

    Answer: XY Scatter

    Scatter, bubble, and stock charts cannot be created as PivotCharts.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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.

  10. 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.

  11. 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.

  12. 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 , 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

  1. store.certiport.com — Fees, retake fee · verified Nov 2026
  2. certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
  3. learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026