How to Add Data to a Pivot Table: 11 Steps

Table of contents:

How to Add Data to a Pivot Table: 11 Steps
How to Add Data to a Pivot Table: 11 Steps
Anonim

This article explains how you can add new data to an existing Microsoft Excel PivotTable. You can perform this change on both a Windows and a Mac computer.

Steps

Add Data to a Pivot Table Step 1
Add Data to a Pivot Table Step 1

Step 1. Open the Excel file which contains the pivot table

Double-click the document icon to open it directly in Excel.

Add Data to a Pivot Table Step 2
Add Data to a Pivot Table Step 2

Step 2. Select the sheet where the data is stored

Click on the tab that contains the data to update (for example Sheet2) displayed at the bottom of the Excel window.

Add Data to a Pivot Table Step 3
Add Data to a Pivot Table Step 3

Step 3. Add new data or edit existing ones

Enter the data you want to add to the pivot table directly below or next to the existing data.

  • For example, if current data is stored in cells from the A1 at the E10, you can insert the new ones starting from the column F. or from the line

    Step 11..

  • If, on the other hand, you simply need to modify the existing information in the pivot table, do so.
Add Data to a Pivot Table Step 4
Add Data to a Pivot Table Step 4

Step 4. Go to the tab where the pivot table is stored

Click on the label of the sheet in which you created the pivot table.

Add Data to a Pivot Table Step 5
Add Data to a Pivot Table Step 5

Step 5. Select the pivot table

Click on the table to select it.

Add Data to a Pivot Table Step 6
Add Data to a Pivot Table Step 6

Step 6. Click on the Options tab or Analyze.

It is located in the center of the green Excel ribbon. A new toolbar will appear.

If you are using a Mac, click on the tab Analyze Pivot Table.

Add Data to a Pivot Table Step 7
Add Data to a Pivot Table Step 7

Step 7. Click the Change Data Source icon

It is located in the "Data" group of the tab Options or Analyze on the Excel ribbon. A drop-down menu will appear.

Add Data to a Pivot Table Step 8
Add Data to a Pivot Table Step 8

Step 8. Click the Change Data Source… option

It is one of the items listed in the drop-down menu that appeared. A dialog box will appear.

Add Data to a Pivot Table Step 9
Add Data to a Pivot Table Step 9

Step 9. Select the data

Click on the cell in the upper left corner of the data range to be analyzed, then drag the mouse cursor to the cell in the lower right corner of the set. The new columns or rows of data you have added will also be included within this selection.

Add Data to a Pivot Table Step 10
Add Data to a Pivot Table Step 10

Step 10. Click the OK button

It is located at the bottom of the window.

Add Data to a Pivot Table Step 11
Add Data to a Pivot Table Step 11

Step 11. Click the Update icon

It is located in the "Data" group of the tab Options or Analyze on the Excel ribbon.

Recommended:

How to Add a Column to a Pivot Table

How to Add a Column to a Pivot Table

This article explains how to create and insert a new column in a PivotTable in Microsoft Excel with the PivotTable tools. You can turn a row, field or value into a column, or create a new one calculated with a custom formula. Steps Method 1 of 2:

How to Add Rows to a Pivot Table

How to Add Rows to a Pivot Table

Pivot tables are used to group and organize data in a spreadsheet. The primary advantage of pivot tables is that you can organize and manipulate data in a variety of ways, based on user needs and the conclusions that can be drawn from the information.

How to Add a Custom Field to a Pivot Table

How to Add a Custom Field to a Pivot Table

On some occasions, you need to enter more information than a normal pivot table can show. In these rare cases, it might be helpful to add a custom and calculated field to the pivot table. You can configure these fields to show averages, percentages, or the maximum and minimum values of a field.

How to Change the Data Source of an Excel Pivot Table

How to Change the Data Source of an Excel Pivot Table

The Microsoft Excel program is designed to allow users to sort and interpret data using advanced features such as pivot tables, formulas and macros. It may happen that a user wants to modify the input data to carry out evaluations on the results.

How to Add a Filter to a Pivot Table

How to Add a Filter to a Pivot Table

PivotTables can provide great support for analyzing the data in a worksheet, but sometimes even the best (best designed) PivotTable can show more information than needed. In these cases, it may be useful to add filters. Once set, a filter can be changed to suit the viewing needs of different users.