Rename a PivotTable or PivotChart

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.

    For Excel 2007-2010, go to PivotTable Tools > Options, 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.

    For Excel 2007-2010, go to PivotChart Tools > Layout tab, in the PivotChart group, click the Chart Name text box.

  3. Type a new name.

  4. Press ENTER.

Rename a PivotTable

  1. Click the PivotTable.

  2. In the PivotTable Analyze ribbon tab, click the PivotTable 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, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×