How to Quickly Copy Chart (Graph) Format in Excel

Watch Video – Copy Chart (Graph) Format in Excel

When you work with Excel charts, it rarely happens that you use the same default chart that Excel creates for you.

In most of the cases, you have to change it’s formatting based on your brand, project, or audience.

Now, if there is a fixed format that you have to use for many charts, it pays off to do all the formatting only once and then simply copy paste the formatting.

Save Time by Copy Pasting Graph/Chart Format in Excel

In this tutorial, I will show you a super quick way to copy and paste Excel chart formats.

Suppose you have spent some time in formatting a chart as shown below (chart on the left). Now when you insert a new chart in Excel, it comes loaded with all the default formatting (chart on the right).

Excel Copy Chart Format - Example

Here are the steps to quickly copy the chart format from the chart on the left and paste in the new chart:

  • Right-click on the chart whose formatting you want to copy and select copy (or select it and use the keyboard shortcut Control + C).Excel Copy Chart Format - Copy
  • Go to Home –> Clipboard –> Paste –> Paste Special. This will open a Paste Special dialog box.Excel Copy Chart Format - Paste Special
  • In the paste special dialog box, select Formats.Excel Copy Chart Format - Formats
  • Click OK.

This would instantly copy the formatting from one chart to the other.

Related Tutorials: