In earlier versions of Microsoft Office Excel, the PivotTable and PivotChart Report command was located on the Data menu and it started the PivotTable and PivotChart Wizard. In Microsoft Office Excel 2007, the PivotTable and PivotChart Report command has been separated into the following two commands:
- The PivotTable command, which displays the Create PivotTable dialog box.
- The PivotChart command, which displays the Create PivotTable with PivotChart dialog box.
Both commands are available from the PivotTable in-group command in the Tables group on the Insert tab. Both dialog boxes have similar user interfaces, and are much simpler to use than the wizard in the earlier version. The difference is that the Create PivotTable dialog box only creates a PivotTable report, and the Create PivotTable with PivotChart dialog box creates a PivotChart report with an associated PivotTable report.
