Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Rename a PivotTable or PivotChart report
 

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

  1. Click the PivotTable report.
  2. On the Options tab, in the PivotTable group, click the PivotTable Name text box.
  3. Type a new name.
  4. Press ENTER.

PivotChart report

  1. Click the PivotChart report.
  2. On the Layout tab, in the Properties group, click the Chart Name text box.
  3. Type a new name.
  4. Press ENTER.
advertisement