How to Copy Chart Format to Another Chart in Excel

This post will guide you how to copy formatting from one chart to another chart in Excel. How do I copy chart formatting to anther chart in Excel 2013/2016.

Assuming that you have a chart in your worksheet, and you want copy its formatting only to another chart in excel. How to do it. You can use Paste Special feature to copy/paste chart formatting only. Or you can also use a short cuts to paste formatting only. You can also create a chart template based on your chart, and then changing chart type for other charts using your created template. So this post will show you three methods to copy formatting from one chart to anther Excel chart.

Copy Chart Formatting with Paste Special


You can use Paste Special feature to copy one chart format to anther chart, just do the following steps:

Step1: select one chart that you want to copy its format. then press Ctrl +C keys on your keyboard to copy the selected chart in your worksheet.  Or you can also go to the Home tab, and click Copy button under Clipboard group.

copy chart format to another chart1

Step2: select another chart that you want to format.

copy chart format to another chart3

Step3: go to Home tab, click paste command under Clipboard group, and select Paste Special option from the context menu. And the paste Special dialog will open.

copy chart format to another chart2

Step4: choose Formats radio option in the Paste Special dialog box, and then click Ok button.

copy chart format to another chart4

Step5: you would see that the chart formatting has been applied to the selected chart in your current worksheet.

copy chart format to another chart5

 

Copy Chart Formatting with Short keys


You can also use a short cut key to achieve the same result of copy chart formatting. You just need to press Ctrl + C to copy the selected original chart, and then select another chart, and press the shortcut key Alt+E+S to paste the formatting only. Then the Paste Special dialog will open. Choose Formats option, click Ok button.

 

Copy Chart Formatting with Creating A Template


There is another way to copy chart formatting only to other charts in Excel. You can create a chart template based on your chart. Just do the following steps:

Step1: select your chart that is used to create template.

Step2: right click on it, and select Save As Template from the context menu. Then Save Chart Template dialog will open.

copy chart format to another chart6

Step3: type the file name in File name text box in the Save Chart Template dialog box, and click Save button to save it to your local disk.

copy chart format to another chart7

Step4: then you can select other charts that you want to reformat. And right click on it, and select Change Chart Type option from the popup menu list. And the Change Chart Type dialog will open.

copy chart format to another chart8

Step5: click Templates button under the All Chart tab in the Change Chart Type dialog box, and select one template that you created before.

copy chart format to another chart9

Step6: click Ok button. The formatting of template has been copied to the selected chart.

copy chart format to another chart5

 

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar