Microsoft Excel Excel Pivot Charts

Question 1

What is the main difference between a PivotChart and a standard Excel chart?

Accepted Answer

A PivotChart is linked to a PivotTable and updates as fields change

Answer

PivotCharts are bound to PivotTable data and include interactive field buttons.

Question 2

Which ribbon tab contains the command to insert a PivotChart?

Accepted Answer

Insert

Answer

PivotChart is in the Charts group on the Insert tab.

Question 3

In the PivotChart Fields pane, fields placed in the Axis (Categories) area correspond to which PivotTable area?

Accepted Answer

Rows

Answer

Axis categories map to Row fields in the underlying PivotTable.

Question 4

Which chart type is NOT available for a PivotChart?

Accepted Answer

XY Scatter

Answer

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

Question 5

What do the gray buttons displayed on a PivotChart allow you to do?

Accepted Answer

Filter, sort, and expand fields directly on the chart

Answer

Field buttons provide interactive filtering and sorting without touching the PivotTable.

Excel Practice Test