How to Change a Pivot Chart’s Location in Excel
When you choose the Design tab’s Move Chart Location command, Excel displays the Move Chart dialog box, as shown. From here, you tell Excel where it should move a chart. In the case of a pivot chart, this means that you’re telling Excel to move the pivot chart to some new chart sheet or to a worksheet.
When you move a pivot chart to a worksheet, the pivot chart becomes a chart object in the worksheet.
To tell Excel to place the pivot chart on to a new sheet, select the New Sheet radio button. Then name the new sheet that Excel should create by entering some clever sheet name in the New Sheet text box.
To tell Excel to add the pivot chart to some existing chart sheet or worksheet as an object, select the Object In radio button. Then select the name of the chart sheet or worksheet from the Object In drop-down list box.
Check out this figure to see how a pivot chart looks when it appears on its own sheet.