How to Move Pivot Charts to Separate Sheets in Excel 2013
Click the Analyze tab under the PivotChart Tools contextual tab to bring its tools to the Ribbon.
If the PivotChart Tools contextual tab doesn’t appear at the end of your Ribbon, click anywhere on the new pivot chart to make this tab reappear.
Rename the generic Chart1 sheet name in the accompanying text box by entering a more descriptive name there.
This is an optional step, but may help you organize later when Excel’s default names are too generic.