Excel 2016 Tips and Tricks
Excel 2016
Lesson 4 – 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
Made with FlippingBook flipbook maker