How to Make a Pivot Table With a Range
A pivot table is used to compare and summarize data. Your data may be pulled from an Excel table, database or external data source. You can specify the range for your table in Excel. There are a few precautions that you should take, however, before creating the pivot table. According to Microsoft Office Online, the data source should be in list format, with column labels in the first row. Each cell in subsequent rows should contain data appropriate to the column heading, and should not include blank cells.
Other People Are Reading
Instructions
-
-
1
Go to Microsoft Excel and open the file containing the Excel table you'll use to create your pivot table.
-
2
Select "Data" and "PivotTable and PivotChart Report" from the menu. The "PivotTable and PivotChart Wizard" will open.
-
-
3
Choose "Microsoft Office Excel list or database" from "Where is the data that you want to analyze?"
-
4
Choose "PivotTable" for the kind of report you want to create, and then click "Next." You will be directed to Step 2 of the wizard to select your range.
-
5
Use your mouse to highlight the areas of the table you want to use (with the wizard still open). To select a data range in a different worksheet, click on the worksheet tab at the bottom of your page and select the range you want.
-
6
Return to the wizard and click on "Next."
-
7
Pick where you'd like to place the pivot table--in a new worksheet or existing one. Then click on the "Layout" button in the wizard to design it. The column headings from your Excel table will be displayed in the wizard as field buttons (on the right-hand side of the wizard).
-
8
Use your mouse to drag the field buttons you need onto the diagram on the left-hand side (where they should appear). Then press "OK" when you are finished.
-
9
Click on the "Options" button to choose your format and data options and press "OK." Click on "Finish" to add the pivot table onto your page.
-
1
