Excel Copy Chart Format and Paste to Another Charts


- Written by Puneet

Let’s say, with your extreme efforts you have formatted a chart and then you realize that you have more charts to format. Applying the same formatting to all the charts is a tedious task the same thing again and again. It’s a pain.

The good news is: there is a super quick solution to your pain. All you need is a few clicks with your mouse. Yes, that’s right. With the paste special option, you can copy formatting from one chart to another just like you do simple copy-pasting. Let’s learn this tip, and WOW everyone.

Steps to Copy Formatting from One Chart to Another

copy chart formatting from one chart to another using paste special.
  1. First of all, right-click on the chart from which you want to copy the chart formatting.
  2. And, then click on the copy.
  3. After that, right-click on the other chart on which you want to apply/paste the formatting.
  4. Now, go to Home tab -> Clipboard -> Paste -> Paste Special.
  5. Here you have a pop-up window.
  6. Select formats and click OK.

Shortcut to Copy Chart Formatting

Yes, you can use a shortcut key to do this.  Just click on the chart you want to copy and use Ctrl + C to copy then select the other chart. In the end, use the shortcut key Alt + E + S to paste/apply the formatting.

Things to Remember

  1. You can’t apply size from one chart to another chart.
  2. You have to apply formatting to every chart one by one, you can’t apply formatting to more than one chart jointly.
  3. If you will try to apply formatting from one chart (for example bar chart) to some other type of chart (for example line chart), it will also change the type of target chart.

Now you don’t have to worry about formatting multiple charts. You have a super quick method to copy chart formatting to another excel chart. I hope you found this tip useful. What do you think? Please share your views with me in the comment section, I’d love to hear from you. 

Must Read Charting Tutorials

  1. How to Add a Horizontal Line in a Chart
  2. How to Add a Vertical Line in a Chart
  3. How to Create a Dynamic Chart Range in Excel
  4. How to Create a Dynamic Chart Title in Excel
  5. Top 10 Advanced Excel Charts You Should Learn
  6. How to Create Interactive Charts in Excel
Last Updated: February 14, 2023

22 thoughts on “Excel Copy Chart Format and Paste to Another Charts”

  1. Thanks. Works with Office 360. It didn’t work in PowerPoint, so I had to paste the chart into Excel and converted It that way.

  2. Doesnt work on excel for mac 2016 nor 2019 either. Just replicates the new pie with the previous data. Thanks for trying_ Would be SO great if it did.

  3. Thank You! You don’t want to know how many I formatted by hand before thinking to google this!

  4. When copying the Diagram format from one document to another the format does not stay. When I close the document that I copied the format from, the document where the document was copied changes format. How can I keep the format intact so that it does not change?

  5. This has been super useful for me. I didn’t know that this was possible. Thanks for sharing, Puneet.


Leave a Comment