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:

Copy a Pivot Chart

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

DOWNLOAD EXCEL WORKBOOK

 

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

Copy a Pivot Chart

 

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

Copy a Pivot Chart

 

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

Copy a Pivot Chart

 

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

Copy a Pivot Chart

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

 

How to Copy a Pivot Chart

Helpful Resource:

Excel Pivot Table

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin