When you create a PivotTable or PivotChart report, Microsoft Office 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.
PivotTable report
- Click the PivotTable report.
- On the Options tab, in the PivotTable group, click the PivotTable Name text box.
- Type a new name.
- Press ENTER.
PivotChart report
- Click the PivotChart report.
- On the Layout tab, in the Properties group, click the Chart Name text box.
- Type a new name.
- Press ENTER.