Design: Move Chart
By
default, a PivotChart is created on the same sheet that has
the PivotTable. You can Move a PivotChart to a different
sheet if you wish. Here are the steps.
5.
Try it: Move a PivotChart
The PivotChart is still selected.
The
PivotChart Tools should be available.
Go to PivotChart Tools ->Design.
Go to Location->Move Chart.
What
Do You See? You will be asked where you want to move the chart.
You can move the chart to a New Sheet. You can also place the chart
as an Object in an existing sheet.
Click CANCEL and keep going, please...