How to Copy Chart Formatting To Another Excel Chart [Trick]

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 a few clicks with your mouse.

Yes, that's right.

With 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. venkat 3 Oct, 18 at 12:14 pm - Reply

    Nice Tip TQ

  2. Neha 3 Oct, 18 at 7:40 am - Reply

    great tip!!!!

  3. Daniel 3 Oct, 18 at 6:55 am - Reply

    Thank you for this information – very helpful

  4. Dilshad Ahmad 1 Oct, 17 at 11:47 am - Reply

    Very Nice & Help Full

    • Puneet 24 Jan, 18 at 6:17 am - Reply

      thanks a lot.

  5. kamran 14 Oct, 16 at 4:16 am - Reply

    thanks for sharing. It’s really helpful.

    • Puneet 14 Oct, 16 at 4:26 am - Reply

      Thanks for your words. Kamran

  6. indzara 29 Aug, 16 at 8:04 pm - Reply

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

    • Puneet 30 Aug, 16 at 8:22 am - Reply

      Welcome Dinesh.

  7. Inet Kemp 21 Feb, 16 at 6:53 pm - Reply

    tx for sharing

    • Puneet 2 Mar, 16 at 5:00 pm - Reply

      Thanks Inet

Leave A Comment