Pinterest Pixel

Copy a Pivot Chart

Bryan
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!

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 it



Copy a Pivot Chart | MyExcelOnline


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.

See also  Drill Down To Audit Using a Pivot Table

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME ā€” no strings attached! Even if itā€™s on day 29, you wonā€™t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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!

Share to...