9.2.3.Add or Remove a Field in a PivotTable or PivotChart Report |
|
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.](../../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.](../../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.](../../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.](../../Microsoft-Office-Excel-2007Images/Add_Or_Remove_Field_In_Pivottable_Or_Pivotchart_Report___Click_Update_To_Manually_Update_Rep.PNG) |