Copy a Pivot Chart

You have tried out Pivot Charts and have done the hard work of creating a Pivot Chart from your Pivot Table. What if you wanted to create another Pivot Chart based on the same Pivot Table? You can quickly copy a Pivot Chart!

Here we have our Pivot Table and Pivot Chart ready:

See how you can do this in just a couple of steps.

Download excel workbookCopying-a-Pivot-Chart.xlsx

STEP 1: Right Click in your Pivot Chart and go to Copy

STEP 2: Right click on a blank spot and select the first Paste Option

STEP 3: Click on the new Pivot Chart then go to PivotChart Tools > Design > Type > Change Chart Type

STEP 4: You can select a different chart type that you prefer. Click OK.

You now have your new Pivot Chart and changed its type!

How to Copy a Pivot Chart

Helpful Resource:

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.