Home > Documents > Excel > Where are Pivot Table and PivotChart Wizard in Microsoft Excel 2007, 2010 and 2013
 

Where are Pivot Table and PivotChart Wizard in Excel 2007, 2010 and 2013

We will always use Pivot Table to organize data which are defined under specified aspects and fields in Excel. It is simple to insert a pivot table in Excel 2003. But when upgrade to Microsoft 2007/2010/2013, users will feel there is no way to get the PivotChart Wizard. This topic points out the position of Pivot Table and PivotChart Wizard, and provides you with two different ways to get them.

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office 2010 and 2013 (365)
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.


Now let’s see where Pivot Table and PivotChart Wizard are in Excel 2007/2010/2013.

Find the feautre on Classic Menu


Open Microsoft Excel 2007/2010/2013, click Menus tab, and you can get back the classic style interface of Excel 2003/XP(2002)/2000. Then, just go to the familiar Data menu, you will find the Pivot Table function listed in the drop down menu. Click the arrow next to PivotTable, and you can get to start Pivot Table and PivotChart Wizard.



If you have not Classic Menu for Excel 2007/2010/2013 installed, you can …


To get the Pivot Table, just click Insert tab, and find out the PivotTable option in Tables group.

Microsoft Excel 2007/2010/2013 hide the PivotChart Wizard, which is not shown in the Ribbon. Without Classic Menu for Excel installed, it is not so intuitive to get this function. If you do need to use PivotChart Wizard, there still are several ways to configure it.

  • Click File Tab, and click “Options” item.
  • Click the Customize Ribbon in the Excel Options window, and then, you will see Customize the Ribbon in the right pane. Choose Commands Not in the Ribbon by clicking the arrow, and then use the scroll bar to search for the PivotTable and PivotChart Wizard.
  • When finally find out the Wizard, click Add to add it into the Ribbon, and then click OK to finish the step.


More Related Articles...

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010 and 2013. You can use Office 2007/2010/2013 immediately without any training. Supports all languages, and all new commands of 2007, 2010 and 2013 have been added into the classic interface.

 

Classic Menu for Office 2010 and 2013

It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010 and 2013.

 
 

Classic Menu for Office 2007

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Classic Menu for Excel 2010

Screen Shot of Classic Menu for Excel

 


 
 

2001- Addintools. All rights reserved.  Privacy Policy  |  Contact Us
If you have any questions or suggestions about our products or web site, please feel free to submit them to us. Thank you very much.