How to Create PivotTable in Excel 2016 Manually

Excel Pivot Table

Making charts with excel is part of the job. In order to make the charts more intuitive to reflect the data, many editors often create PivotTable in Excel 2016, but many friends are not clear about how to make the charts. Here is how to create PivotTable in Excel 2016.

Steps to create PivotTable in Excel 2016 manually

Step 1: Open the data document in excel 2016, which is the cost reimbursement situation of 3 salesmen in 2017-2018.

open the data document

Step 2: Click any cell in the data area with the mouse, and click Insert, go to Tables > PivotTable.

click PivotTable

Step 3: At this time, a dialog box “Create PivotTable” pops up. You can see the data (Sheet1!$A$1:$F$15) we selected is displayed in the text behind “Table/Range“, then select New Worksheet and click OK.

select new worksheet

Step 4: In the PivotTable Fields list, click the triangle symbol on the right and select Fields Section and Areas Section Side-By-Side.

click the triangle symbol

Step 5: Drag Year into FILTERS area, drag Usage into ROWS area and drag Zhang San, Li Si, Wang Wu into the VALUES area.

drag to the appropriate position

Step 6: After you select the options that need to be summarized, you can see that the table data will be summed up well. Click any cell that has aggregated the data, click Insert and choose the chart format you want.

choose the chart format

Step 7: Next, a PivotTable will be generated. Then you can see at a glance the sum of each person’s cost for operating and recruiting respectively.

generate a PivotTable

The above is the method of creating the PivotTable in Excel 2016. The operation is so simple, you just follow the above steps to operate, I hope to help you!

You May Also Like

About the Author: Darren

Leave a Reply

Your email address will not be published. Required fields are marked *