warehousegaq.blogg.se - How to rotate an excel spreadsheet and insert into word

This imports the entire workbook into your Word document, so you can end up with a very large file. In Word, do Edit > Paste, or just ctrl-v.Īlternatively, you can paste the chart as an Excel chart. 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.

in Word 2007 and later versions, on the Home tab, click the little arrow below the Paste button (it's called a split button you need the bottom half), and choose Paste Special.

in Word 2003 and earlier versions, do Edit > Paste Special.

To link your chart to its source you need the Paste Special dialog. 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.

How do you control the size of text in the chart?ĭo you want to link your chart to the source file?.

How do you want text to flow around your chart?.

Do you want to link your chart to the source workbook?.

This page explains the ins and outs of copying an Excel chart into Word.

double-click the chart and on the Layout tab, choose In line with text.

choose Edit > Paste Special and choose to paste as Picture (Enhanced Metafile).Unless you have good reasons to choose some other settings, the best way to copy a chart into Excel is to: