Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

Steps

Practice Data

1. Select any cell in the table.

Click anywhere in the PivotTable

The active cell moves accordingly.

2. Select the Analyze tab.

Click Analyze

The Analyze tab is displayed.

3. In the Tools group, click the PivotChart icon.

Click PivotChart

The Insert Chart dialog box opens.

4. Select the chart you want to use. The option is selected.

Click the Stacked Column chart.

5. Select OK .

Click

The chart dialog box closes, and the PivotChart Fields pane and PivotChart are displayed. 6. Drag the desired fields from the top half of the PivotChart Fields pane to the required area of the lower half of the pane. The field appears in the required area.

Drag Month to the Filters box

7. Repeat step 6 as required for the

Follow the instructions shown below the table to complete the PivotChart.

fields to be shown on the PivotChart. The fields are shown in their respective areas in the lower section of the PivotChart Fields pane.

Drag the Region field to the Legend Fields box.

Page 130

OFFICEPRO, Inc.