How to Copy a Chart from Excel to Word (2 Easy Ways)

While working in Microsoft Excel, we often have to create a Chart to understand data easily. Sometimes we need to copy a chart from Excel to Word for the convenience of our work. For those who are lazy like me, this article will be very helpful for them. Because I will show you how to copy a chart from Excel to Word. Microsoft Excel offers you a keyboard shortcut and the paste special command helps you to copy a chart from Excel to word. This is an easy and time-saving task as well.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Create a Chart in Excel

Here, we will learn how to create a chart in Excel. Let’s go through the process below.

Steps:

• First of all, select the range that you want to demonstrate in the Column Chart. From my dataset, I selected C4:D9. Hence, from your Insert tab, go to,

Insert → Charts → Insert Column or Bar Chart → 3-D Column

• As a result, you will be able to create a 3-D column chart.

• Now, we will change the color of the 3-D column chart. To do that, select any column and press right-click on that column. Hence, select a color you want from the Fill color We have selected Orange color.

• After that, our chart becomes like the below screenshot.

• Further, we will add the Data Labels to the chart. To do that, look at the below screenshot. Finally, you will be able to create a 3-D column chart.

2 Suitable Ways to Copy a Chart from Excel to Word

Let us have a data set like this. We have a record of the revenue earned by the sales representatives of XYZ group. Our Excel workbook contains several sheets. We will copy a chart from Excel to Word, using the keyboard shortcuts and the Paste Special command as well. Here’s an overview of the dataset for today’s task.

1. Applying Keyboard Shortcuts to Copy Chart from Excel to Word

In this method, we will learn how to copy a chart from Excel to Word by applying keyboard shortcuts. From our dataset, we can easily do that. Let’s follow the instructions below to learn!

Steps:

• First of all, we will select the chart.

• After selecting the chart, press  Ctrl + C  simultaneously on your keyboard to copy the chart.

• Hence, we will open our Word After that, we will press  Ctrl + P  simultaneously on our keyboard to paste the copied chart into the Word file.
• As a result, you will be able to copy the chart from Excel to Word.

Read More: How to Convert Excel to Word Labels (With Easy Steps)

2. Using Paste Special Command to Copy Chart from Excel to Word

Now, we will use the Paste Special option to chart data from Excel to Word. The Paste Special option is a very effective tool in Excel to chart data from Excel to Word. Let’s follow the instructions below to learn!

Steps:

• First of all, we will select the chart > right-click > select Copy from the context menu.

• Afterward, we will open our Word Hence, from your Home tab, go to,

Home → Clipboard → Paste → Paste Special

• As a result, a Paste Special dialog box will appear in front of you. From the Paste Special dialog box, firstly, select the Paste Secondly, select Microsoft Excel Chart Object under the As drop-down list. At last, press the OK option.

• Finally, we can see the chart in the Word file.

Read More: How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)

Transfer Chart Data from Excel to Word Automatically

Here, we can copy the data as a picture, and therefore, the data is not editable in Word. Let’s follow the instructions below to learn!

Steps:

• First of all, we will select the chart.

• Hence, from your Home tab, go to,

Home → Clipboard → Copy→ Copy As Picture

• As a result, a Copy Picture window will appear. From the Copy Picture window, do like the below screenshot.

• After that, we will open our Word Hence, from your Home tab, go to,

Home → Clipboard → Paste → Paste Special

• As a result, a Paste Special dialog box will appear in front of you. From the Paste Special dialog box, firstly, select the Paste Secondly, select Picture (Enhanced Metafile) under the As drop-down list. At last, press the OK option.

• Finally, we will be able to transfer the chart from Excel to Word which has been given in the below screenshot.

Read More: How to Transfer Data from Excel to Word Automatically (5 Methods)

Bottom Line

• You can copy a chart by pressing  Ctrl + C  simultaneously on your keyboard.
• To paste the copied portion press  Ctrl + P  simultaneously.
• You can also use  Ctrl + Alt + V  to pop up the Paste Special dialog box in Microsoft Word.

Conclusion

I hope all of the suitable methods mentioned above to copy a chart from excel to word will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

Related Articles

• How to Open Word Document and Save As PDF or Docx with VBA Excel
• Excel VBA: Open Word Document and Paste (3 Suitable Examples)
• Generate a Word Document from an Excel Macro
• How to Put a Large Excel Table into Word (7 Easy Methods)
• Insert an Excel Spreadsheet into Word (4 Easy Methods)
• How to Create Multiple Word Documents from Excel (3 Easy Methods)
• Excel VBA: Open Word Document and Replace Text (6 Examples)