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.
- Go to PivotTable Tools > Analyze, and 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.
- Go to PivotTable Tools > Analyze, and in the Active Field group, click the Active Field text box.
- Type a new name.
- Press ENTER.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.