How to create pivot tables in Excel 2007?
62This is the way to create it using Word 2003.
This one is relatively simple. Go into the data menu and select Pivot Table and Pivot Chart Report:
- This will bring you to the Pivot Table Wizard. There it will ask you where the data is located (make your selection) and what type of report you want to create (a Pivot Table or Chart select pivot table).
Select Next:
- It will now ask you where the data is that you want to use (you can select a range of data in the current workbook or you can use the browse button to select a different data sheet)
Select Next:
- It asks where you want to put your Pivot Table in a new or exsisting worksheet (your choice based on how you want it to look. If you choose to place it in the current sheet you must select the cell range where you'd like it to be placed)
Select Finish:
- Your Pivot Table will be created either within your current worksheet or in a new document. Here you will be able to edit the Pivot Table's format, data or create a Pivot Chart.
I hope this helps!!
PrintShare it! — Rate it: up down flag this hub








