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 its 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.

Other Excel tutorials you may find useful

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

2 thoughts on “How to Quickly Copy Chart (Graph) Format in Excel”

  1. I’m not seeing this dialog box in Excel 2010…what version were you using in this example? When I right click on the second chart, I don’t have a Paste Special option.

    Reply

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster