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 Chart3-D Column

Create a Chart in Excel

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

Create a Chart in Excel

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

how to copy a chart from excel to word


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.

Applying Keyboard Shortcuts to Copy Chart from Excel to Word

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

Applying Keyboard Shortcuts to Copy 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.

Using Paste Special Command to Copy Chart from Excel to Word

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

Home Clipboard PastePaste 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.

Using Paste Special Command to Copy Chart from Excel to Word

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

Using Paste Special Command to Copy Chart from Excel to Word

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.

Transfer Chart Data from Excel to Word Automatically

  • Hence, from your Home tab, go to,

Home Clipboard CopyCopy As Picture

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

Transfer Chart Data from Excel to Word Automatically

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

Home Clipboard PastePaste 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.

Transfer Chart Data from Excel to Word Automatically

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

Transfer Chart Data from Excel to Word Automatically

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

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo