Show All

Hide All

For best results in a PivotChart report (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.), work in the associated PivotTable report (associated PivotTable report: The PivotTable report that supplies the source data to the PivotChart report. It is created automatically when you create a new PivotChart report. When you change the layout of either report, the other also changes.).

1. Determine whether the formula is in a calculated field (calculated field: A field in a PivotTable report or PivotChart report that uses a formula you create. Calculated fields can perform calculations by using the contents of other fields in the PivotTable report or PivotChart report.) or a calculated item (calculated item: An item within a PivotTable field or PivotChart field that uses a formula you create. Calculated items can perform calculations by using the contents of other items within the same field of the PivotTable report or PivotChart report.).

   Calculated fields appear in the PivotTable Field List window. Calculated items appear as items (item: A subcategory of a field in PivotTable and PivotChart reports. For instance, the field "Month" could have items such as "January," "February," and so on.) within other fields.

2. Do one of the following:

   Delete a calculated field

   1. Click the report.
   2. On the PivotTable toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), click PivotTable or PivotChart, point to Formulas, and then click Calculated Field.
   3. In the Name box, click the field you want to delete.
   4. Click Delete.

   Delete a calculated item

   1. Click the field with the item you want to delete.
   2. On the PivotTable toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), click PivotTable or PivotChart, point to Formulas, and then click Calculated Item.
   3. In the Name box, click the item you want to delete.
   4. Click Delete.

Note  When you delete a formula from a PivotChart report or its associated PivotTable report, some chart formatting may be lost.

Tip