Microsoft
70-779 · Question #51
You create a PivotTable and a Pivot Chart as shown in the following exhibit. You need to decrease the number of columns in the PivotChart to six. What should you do?
The correct answer is C. Right-click the PivotChart, click Select Data, and then remove five of the bins from the Horizontal. https://a4accounting.com.au/switching-rows-and-columns-in-a-pivotchart/
Visualize data by using Microsoft Excel
Question
You create a PivotTable and a Pivot Chart as shown in the following exhibit. You need to decrease the number of columns in the PivotChart to six. What should you do?
Exhibit
Options
- ARight-click the PivotChart, click Format Axis, and then change Interval between marks to 2.
- BRight-click the PivotTable, click Group, and then change By from 10 to 20.
- CRight-click the PivotChart, click Select Data, and then remove five of the bins from the Horizontal
- DChange the chart type to Histogram.
How the community answered
(42 responses)- A5% (2)
- B7% (3)
- C74% (31)
- D14% (6)
Explanation
https://a4accounting.com.au/switching-rows-and-columns-in-a-pivotchart/
Topics
#PivotChart#histogram#bins#chart formatting
Community Discussion
No community discussion yet for this question.