Excel 2016 Tips and Tricks

Excel 2016

Lesson – Creating/Revising PivotTables

A PivotChart report



P ROCEDURES

1. Select any cell in the PivotTable.

2. Click the PivotTable Tools Analyze tab.

3. In the Tools group, click PivotChart .

4. Click the chart you want to use.

5. Click

.

6. Drag the desired fields from the top half of the PivotTable Fields pane to the

required area of the lower half of the pane.

7. Repeat step 6 as required for the fields to be shown on the PivotChart.



S TEP - BY -S TEP

Create a PivotChart report.

Display the Sales worksheet.

OFFICEPRO, Inc.

Page 129