Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

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

quick charting copy chart formatting to another excel chartDo you know how to Copy Chart Formatting To Another Excel Chart?

Let’s say, with your extreme efforts, you have formatted a chart. And, you realize that you have more charts to format.

It’s a pain.

But, I have a super quick solution to your pain.

All you need just a few clicks with your mouse.

So the game is.

You can use paste special option to apply formatting from one chart to another chart or charts.

Learn this tip, and WOW everyone.

Download this Quick PDF Guide to learn how to copy chart formatting to another excel chart.

Steps to Copy Format From One Chart to Another

  • Right-click on the chart from which you want to copy the chart formatting.
  • Click on the copy.
  • Right-click on the other chart on which you want to apply/paste the formatting.
  • Go to Home tab -> Clipboard -> Paste -> Paste Special.
  • Now, you have a pop-up window. Select formats.

Copy & Apply Formatting from One Chart to Another using Paste Special

  • Click OK

Copy & Apply Formatting from One Chart to Another using Paste Special

Shortcut to Copy Chart Formatting

Yes, you can use a shortcut key to do this.

  • Click on the chart you want to copy.
  • Use Ctrl + C to copy.
  • Select the other chart.
  • Use the shortcut key Alt + E + S to paste/apply the formatting.

Things to Remember

  • You can’t apply size from one chart to another chart.
  • You have to apply formatting to every chart one by one, you can’t apply formatting to more than one chart jointly.
  • 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.

Copy & Apply Formatting from One Chart to Another using Paste Special on Different Charts

Download this sample file to try it yourself. And, Please don’t forget to download my Excel Productivity Guide from here.

Over To You

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.

And, if you have any other quick method to copy chart formatting to another excel chart. GO and hit the comment box.

Want To Learn More?

Here are some quick tips to apply formatting in excel in 5 Seconds.