How to Copy Chart in Excel (5 Easy Ways)

Download Practice Workbook


You can copy a chart, with or without formatting, to the same or different worksheets, workbooks, or even other office applications.

The following sample dataset will be used for illustration.

Revenue Data of ABC Company

 


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

Select the chart, right-click on it and from the context menu, select Copy or press Ctrl+C.

copying the chart

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 cannot edit or make changes to the chart after it is pasted.

Method 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’s steps are similar to Method 1.

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

We chose the worksheet labeled as Chart.

Copying chart and selecting worksheet

In the Chart sheet, select a cell where you want the chart to be placed. We selected cell B10. Right-click and from the Paste Options, chose one of the options.

paste in new worksheet


Method 3 – Copying Charts to Different Office Applications

We will illustrate the steps 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

Open a Word document, go to the Home tab, click on Paste and choose any of the 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.

We chose the KeepSource Formatting & Embed Workbook option for pasting and the following output.

Output in Word document


Method 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. In this method, we will illustrate the steps 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 chart.

Dataset for copying chart format

Select the first chart and select Copy from the Home tab.

Copying chart for pasting only format

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

In the pop-up box, select the Formats option and press OK.

Selecting Formats option from paste special options

You can see that the second chart has the same format as the first chart.

Chart format pasted in new chart

Read More: How to Copy Chart Format in Excel


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

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

copying chart

Select a cell below the other dataset and right-click. Choose the option Keep Source Formatting from the pasting options.

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

A box named Select Data Source will pop up. Click on the upside arrow on the right side of the Chart data range option.

click on chart data range option

Insert the new range of data. We have selected H4:L8 cell range.

enter new data source

Press OK.

press ok

The new chart’s data will be changed to that of the other dataset.

output of copying chart with different data

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


Copy Chart in Excel: Knowledge Hub


<< Go Back To Excel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!

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