Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Move Pivot Charts in Excel 2013

Although Excel 2013 automatically creates all new pivot charts on the same worksheet as the pivot table, you may find it easier to customize and work with it if you move the chart to its own chart sheet in the workbook. To move a new pivot chart to its own chart sheet in the workbook, you follow these steps:

1

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.

2

Click the Move Chart button in the Actions group.

Excel opens a Move Chart dialog box.

3

Click the New Sheet button in the Move Chart dialog box.

(Optional) Rename the generic Chart1 sheet name in the accompanying text box by entering a more descriptive name there.

4

Click OK to close the Move Chart dialog box and open the new chart sheet with your pivot chart.

Here is a clustered column pivot chart after moving the chart to its own chart sheet in the workbook.

   
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!