You can quickly change the Custom Name of a field or item without displaying the Field Settings or Value Field Settings dialog boxes. The following procedures do not change the Source Name of the field or item.
PivotTable report
- Click the field or item that you want to rename.
- On the Options tab, in the Active Field group, click the Active Field text box.
- Type a new name.
- Press ENTER.
Note Renaming a numeric item changes it to text, which sorts separately from numeric values and can't be grouped with numeric items.
PivotChart report
- Click the object in the chart (such as a bar, line, or column) that corresponds to the field or item that you want to rename.
- On the Analyze tab, in the Active Field group, click the Active Field text box.
- Type a new name.
- Press ENTER.