Click any field in the PivotTable report.
Select/clear the check boxes next to the fields you want to include or exclude
from the PivotTable and PivotChart.
![Click any field in the PivotTable report. Select/clear the check boxes next to the fields you want to include or exclude from the PivotTable and PivotChart.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Or_Remove_Field_In_Pivottable_Or_Pivotchart_Report___Click_Any_Field_In_Pivottable_Repor.PNG)
To change the position of a field, drag the field in the Field list to:
Values to display summary numeric data.
Row Labels to display fields as rows on the side of the report. Axis field in a PivotChart.
Column Labels to display fields as columns at the top of the report. Legend field in a PivotChart.
Report Filter to filter the entire report based on the selected item in the report filter.
![Report Filter to filter the entire report based on the selected item in the report filter.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Or_Remove_Field_In_Pivottable_Or_Pivotchart_Report___Report_Filter_To_Filter_Entire_Repo.PNG)
To enable manual layout updating, select the Defer layout update check box.
![To enable manual layout updating, select the Defer layout update check box.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Or_Remove_Field_In_Pivottable_Or_Pivotchart_Report___To_Enable_Manual_Layout_Updating_Se.PNG)
Click Update to manually update the report layout.
![Click Update to manually update the report layout.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Or_Remove_Field_In_Pivottable_Or_Pivotchart_Report___Click_Update_To_Manually_Update_Rep.PNG)