If you select a cell in a pivot table and click the Chart Wizard button on the toolbar, a default pivot chart is created, on a new chart sheet. Sometimes you might want to step through the Chart Wizard, so you can set the options as you create the pivot chart.