How to Copy Chart in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will show you how to copy a chart in Excel in 5 easy ways. Excel charts are an excellent tool for visualizing or comparing different data. Excel allows users to create and customize charts to understand data trends and patterns better. In this process, copying charts is a common phenomenon.

You can copy a chart with or without its formatting in the same or different worksheets or workbooks, even to a different office application. I hope this article will cover everything about copying a chart in Excel.

copy charts in Excel


Download Practice Workbook

You can download the practice workbook here.


Copy Chart in Excel: 5 Easy Ways

In this article, we will demonstrate 5 easy ways to copy charts in Excel. For that, we have a dataset containing revenues of different regions for a company. To illustrate these data, we inserted a chart that makes visualizing the table more clearly.

Revenue Data of ABC Company

Now, let us see how to copy the chart in 5 different ways.


1. Using Context Menu to Copy Chart in Same Worksheet

This first method uses a context menu for copying the chart in the same worksheet. First, select the chart, right-click on it, and from the context menu, select Copy, or just press Ctrl+C.

copying the chart

Then, for pasting the copied chart, select a cell where you want your chart. Right-click on the cell, and from Paste Options in the context menu, choose any option or press Ctrl+V.

Choose one pasting option

The three pasting options are:

  • Use Destination Theme: If you choose this option, the chart will be formatted as the cell or worksheet is formatted, losing its previous formatting.
  • Keep Source Formatting: This option keeps the formatting of the copied chart.
  • Picture: If you choose this option, the chart will be pasted as a picture and keep formatting as a source chart. However, you can not edit or make changes afterward to it.

2. Copying Charts to Different Worksheets

This method shows you what steps to follow if you need to copy the chart to a different worksheet. This method follows similar steps to the first method.

First, select the chart, right-click it, and choose Copy from the context menu. Then select the worksheet where you want your chart to be pasted.

We chose the Chart named worksheet.

Copying chart and selecting worksheet

After that, in the Chart sheet, select a cell where you want the chart to be placed. We selected cell B10 and right-clicked on it, and from the Paste Options, chose one.

paste in new worksheet


3. Copying Charts to Different Office Applications

We might need to copy the chart to another Microsoft Office Application for documentation or other purposes. So, in this method, we will demonstrate how to copy a chart to a Word document.

Select the chart from the Home tab and click the Copy option to copy the chart.

selecting copy option from the ribbon

Now that the chart is copied open a Word document, go to the Home tab, click on Paste, and choose any pasting options.

pasting in word document

The pasting options are:

  • Use Destination Theme & Embed Workbook: This option pastes the chart in Word by matching the destination theme.
  • Keep Source Formatting & Embed Workbook: The chart will keep the Excel formatting if you choose this option.
  • Use Destination Theme & Link Data: This option matches the theme of the Word document and links the chart with Excel. So, when the Excel file is updated, the chart in the Word document is also updated.
  • Keep Source Formatting & Link Data: This option links the data with Excel and keeps the source formatting. So, with the data change in Excel, the chart in Word also changes.
  • Picture: This option pastes the chart as a picture, neither updating the data nor changing the formatting.
Note: You can also use the keyboard shortcut Ctrl+V for pasting in a Word document, but in that case, the chart will be pasted in the default pasting option, which is to Use Destination Theme & Link Data.

Here, we chose the KeepSource Formatting & Embed Workbook option for pasting, and the outcome looks like this.

Output in Word document


4. Copying Only Chart Format

When you need to create charts from different datasets and want to format all the charts in the same format, then editing each chart to achieve the same format every time is hectic and time-consuming. So, in this method, we will show you how to copy only the chart format in Excel.

In the image below, we have two datasets and their corresponding charts. We want the second chart to be in the same format as the first one.

Dataset for copying chart format

First, select the first chart, then select Copy from the Home tab or press Ctrl+C.

Copying chart for pasting only format

Next, select the second chart on the right side, select Paste Special option from the Paste in the Home tab, or you can use the keyboard shortcut Alt+E+S.

Selecting pasting special option from ribbon

After that, a message box will appear. Select the Formats option and press OK.

Selecting Formats option from paste special options

Lastly, you can see that the second chart is also in the same format as the first one.

Chart format pasted in new chart

Read More: How to Copy Chart Format in Excel


5. Replicating Chart with Different Data in Excel

When we need to replicate a chart with different data, meaning to keep the format, we can create the chart and copy only the format to the charts. However, we can also do it by copying the chart first and then changing the cell references of pasted charts.

First, select the chart, right-click it, and select Copy from the context menu.

copying chart

Next, select a cell below the other dataset and right-click. Choose the option Keep Source Formatting from the pasting options or press Ctrl+V.

pasting chart keeping source formatting

This new chart is now linked to the previous dataset, but we need to link it with another dataset. Select the new chart, go to the Chart Design tab, and click Select Data.

Choose select data option from chart design tab

Next, a box named Select Data Source will appear. Click on the upside arrow on the right side of the Chart data range option.

click on chart data range option

Next, insert the new range of data. We selected H4:L8 cell range.

enter new data source

Then, press OK.

press ok

Lastly, you can see that the new chart’s data changed to the other dataset.

output of copying chart with different data

Read More: How to Duplicate Chart with Different Data in Excel


Things to Remember

  • The keyboard shortcut for the Paste Special option is Alt+E+S.
  • In Excel, there are three pasting options Use Destination Theme, Keep Source Formatting, and Picture.
  • While pasting the chart in Word to Excel, there are five options for pasting the chart. They are: Use Destination Theme & Embed Workbook, Keep Source Formatting & Embed Workbook, Use Destination Theme & Link Data, Keep Source Formatting & Link Data, Picture.

Frequently Asked Questions

1. What is the shortcut to copy a chart in Excel?

Ctrl+C is the keyboard shortcut for copying a chart in Excel.

2. Can you copy a chart format in Excel?

Yes, you can copy the chart format in Excel. Press Alt+E+S after copying the chart and choose the Formats option.

3. How to Copy a chart from Excel to Word without losing formatting?

To Copy a chart from Excel to Word without losing formatting, copy the chart from Excel and in Word document, go to the Paste option in the Home tab, and select Keep Source Formatting & Embed Workbook.


Conclusion

This article demonstrated 5 easy ways to copy a chart in Excel. Here, we showed how to copy charts in the same and different worksheets and different office applications. In addition to that, we showed copying only chart formatting and linking copied charts to a separate worksheet. All these methods are essential for visually presenting complex data. It facilitates consistency, saves time, and improves data-driven decision-making. All Excel users would benefit from mastering this ability.


Copy Chart in Excel: Knowledge Hub


<< Go Back To Excel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Priti
Priti

Priti Halder holds a BSc degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. She has been a part of the ExcelDemy project for 6 months and during this time, she has written over 30 articles and 5 comments for the platform. Priti is currently employed as an Excel and VBA content developer and provides effective solutions to various Excel-related issues. She is passionate about expanding her knowledge of data analysis and Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo