A PivotChart ________.
A)is not altered by filters and slicers
B)represents the consolidated data of a PivotTable visually
C)does not use a PivotTable's COLUMNS area fields
D)displays fields from the VALUES area on the legend

Question

Quizplus · Accepted Answer

A PivotChart represents the consolidated data of a PivotTable visually. The chart is based on the underlying PivotTable, and any changes to the PivotTable will be reflected in the chart. The filters and slicers applied to the PivotTable will also be reflected in the PivotChart. A PivotChart may use the COLUMNS area fields from a PivotTable, and can display fields from the VALUES area on the legend.