Pinterest Pixel

Copy a Pivot Chart

You have tried out Pivot Charts and have done the hard work of creating a Pivot Chart from... read more

Download Excel Workbook
Bryan
Posted on

Overview

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

Download excel workbookCopying-a-Pivot-Chart.xlsx

 

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

Copy a Pivot Chart | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!