Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

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

  1. Click the PivotTable.

  2. Go to PivotTable Tools > Analyze, and in the PivotTable group, click the PivotTable Name text box.

  3. Type a new name.

  4. Press ENTER.

Rename a PivotChart

  1. Click the PivotChart.

  2. Go to PivotChart Tools > Analyze tab, in the PivotChart group, click the Chart Name text box.

  3. Type a new name.

  4. Press ENTER.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Create a PivotTable

Use the Field List to arrange fields in a PivotTable

Create a PivotChart

Use slicers to filter data

Create a PivotTable timeline to filter dates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.