Decide whether to make the layout changes on the screen or in the wizard. Usually you can make changes on the screen. If changes result in long delays in retrieving and displaying data, use the wizard.
Change the layout on the screen
Click the report.
Display the field buttons if they are hidden: click PivotChart on the PivotTable toolbar and make sure that the Hide PivotChart Field Buttons command is not checked.
Do one or more of the following:
Change the layout on the sheet
Fields with icons in the PivotTable Field List window can be used only in the series, category, and page areas. Fields with icons can be used only in the data area. Fields with icons can be used in any area.
Add or remove a field on the sheet
Add a field Drag the field from the PivotTable Field List window to the area of the report for the type of field you want to create.
Fields with icons in the PivotTable Field List window can be used only in the series, category, and page areas. Fields with icons can be used only in the data area. Fields with icons can be used in any area.
Remove a field Drag the field button out of the report.
Use the wizard to change the layout
Use the COLUMN area for series fields and the ROW area for category fields.
Some fields can only be used in some of the areas. If you drop a field in an area where it can't be used, the field won't appear in the area.
Note Changing the layout of a PivotChart report also affects its associated PivotTable report, and some chart formatting may be lost.