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.

Copy a Pivot Chart | MyExcelOnline



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



Get access to 30+ Microsoft Excel & Office courses for ONLY $1.

Click here to get this limited-time $1 offer!


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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn