Instructions on how to copy charts from Excel to Word

It is similar to copying data from Excel to Word . Usually very few people who draw charts on Word often draw charts on Excel and then copy them to Word . In case you have to create a chart on Word to make a report or presentation . But you don't know how to copy. The following article The network administrator will show you how to copy a chart from Excel to Word documents.

See also: How to copy data from Excel to Word?

1. Step 1

On Excel , select the Embedded Char t chart or the Chart Sheet (also a Sheet in Workbook , but it contains only one graph) that you want to copy to Word .

2. Step 2

On the Home Tab , in the Clipboard group , click Copy .

Or the fastest way is on the keyboard press Ctrl + C.

3. Step 3

Open Word and then click on the location where you want to paste (copy) the copied chart from Excel .

4. Step 4

On the Home Tab , in the Clipboard group, click Paste.

Or the fastest way is to press Ctrl + V.

5. Step 5

Click on Paste Options option (paste option) located next to the chart, then do one of the steps below:

1. If you want to paste (paste) the chart with a data link, click Chart (linked to Excel data) .

1. If you want to paste (chart) charts including access to all Workbooks in Word , click the Excel Chart (entire workbook).

1. If you want to paste (paste) the chart as a still image (normal image), click Paste as Picture .

1. If you want to paste (paste) the chart as the original format, click Keep Source Formatting .

1. If you want to paste (paste) the chart and reformat the chart using Word themes, click Use Destination Theme.

6. Note

If the Paste Options option button is not available when you paste (paste) a chart on Word , you must proceed to open   Compatibility Mode ( compatible mode ) on Word . In Compatibility Mode ( compatible mode ), your chart will be pasted (pasted) like pasting a still image.

Further reference: 10 ways to recover corrupted Excel files

7. Tips

- To paste (paste) a chart into other formats, click the arrow under the Paste button, then click Paste Special. An As dialog window appears. On the list listed on the As dialog box, select the format you want to paste.

- To paste (paste) a chart as an editable object with Excel , click on Microsoft Office Excel Chart Object. To insert a file icon so that when you click on the icon the file can open your chart, select Display as icon.

- To paste (paste) the chart as an Object Linking and Embedding . Create an application icon so that when you click on the icon, you can view your chart. Click Microsoft Office Excel Chart Object , then click Display as icon on the check box. You can click on the icon to open the application and view your chart.

- To paste (paste) your chart as a still image (normal image), click the Picture Option option or Bitmap Option. Picture format (Picture format) usually displays better image quality than Bitmap format.

- Click on the Microsoft Office Graphic Object to paste (paste) your chart as a Graphic Object (graphic object) that can be used to edit the charting tools. To insert a file icon that when you click on the icon can open the chart, select Display as icon . Microsoft Office Graphic Object is not displayed if you use Compatibility Mode on Word .

- Click Paste link (paste link) to paste (paste) the chart containing the data link on the original Excel chart. When the chart that you paste (paste) will update the changed data. This option is not available when you are using Compatibility Mode on Word.

- Also you can create a chart directly on Microsoft Office Word 2007 by clicking on Chart on Ribbon (insert tab, illustration). Then use charting tools to adjust or format your chart. The chart you create on Word will be embedded in Word documents and stored on a Worksheet containing that Word file in Excel . In Compatibility Mode ( compatible mode ), you can create a chart on Word using Microsoft Graph.

Good luck!