When you create a PivotTable or PivotChart, Excel assigns default names to each of these objects by using the following naming conventions: PivotTable1, PivotTable2, and so on; and Chart 1, Chart 2, and so on. However, you can change the name of each object to make it more meaningful to you.
Rename a PivotTable
-
Click the PivotTable.
-
Go to PivotTable Tools > Analyze, and in the PivotTable group, click the PivotTable Name text box.
For Excel 2007-2010, go to PivotTable Tools > Options, and in the PivotTable group, click the PivotTable Name text box.
-
Type a new name.
-
Press ENTER.
Rename a PivotChart
-
Click the PivotChart.
-
Go to PivotChart Tools > Analyze tab, in the PivotChart group, click the Chart Name text box.
For Excel 2007-2010, go to PivotChart Tools > Layout tab, in the PivotChart group, click the Chart Name text box.
-
Type a new name.
-
Press ENTER.
Rename a PivotTable
-
Click the PivotTable.
-
In the PivotTable Analyze ribbon tab, click the PivotTable Name 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.
