- How to import excel spreadsheet into word for labels how to#
- How to import excel spreadsheet into word for labels update#
For more information, see Is your image slipping? How to get your images to stand still. Otherwise (that is, in most cases), your chart should be in-line. If you want text over the chart, behind the chart, or to wrap around the chart, then your chart needs to float. This controls the placement of your chart and how text flows around the chart. Your chart can sit in Word either in-line or floating. How do you want the text to flow around the chart? Should your chart be in-line or floating? When you're finished, click outside the chart, in the main body of the Word document. If your chart is in Word as an Excel chart, you can double-click the chart to edit the chart or anything else in the Excel file, including the source data for the chart. In Word, do Edit > Paste, or just ctrl-v. Make sure it shows 8 hollow round markers on the edge.
In Excel, click the chart once and be sure it shows 8 small black square markers on the edge.In Word, choose Edit > Paste Special and choose to paste as a Picture (Enhanced Metafile). To paste your Excel chart as a picture, follow one of these methods: If you do this, the file size is small and you can treat it like a picture: re-size, rotate, convert to a drawing object so you can edit the text, and re-colour elements of the chart.įor most tasks, pasting as a picture is my preferred method. Here are the main options: Paste as a picture
Your options for pasting depend on what version of Word you have, and whether you are linking the chart in Word to the source Excel data file.
When you return to Word, your Word document will reflect your changes. If you link your chart, when you double-click the chart in Word, Excel opens the original file, where you can edit it. Within the Paste Special dialog, select the Paste Link option (Figure 2).įigure 2: To link the chart in your Word document to its source Excel file, choose the Paste link option.
How to import excel spreadsheet into word for labels update#
If you do that, whenever you make a change in the source Excel file, Word can update the chart in your document to reflect the changes in the source Excel file. You can paste a chart into Word and link it to its source file.