Now you will see an Excel spreadsheet in word shows that in the below screenshot. Click down the arrow mark near Table. Click on Insert which is at the top menu. You can insert an Excel spreadsheet as a table.
![]() Do Edit > Copy, or just ctrl-c. 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). In Excel, click the chart. 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.For most tasks, pasting as a picture is my preferred method.To paste your Excel chart as a picture, follow one of these methods: In Word, choose Edit > Paste Special and choose to paste as an Microsoft Office Excel Chart Object. In Excel, click the chart. And, you risk disclosing the source data—and anything else that is in the Excel file—to the reader of your Word document.To paste your Excel chart as an Excel chart object, follow one of these methods: This imports the entire workbook into your Word document, so you can end up with a very large file. Free internet explorer 9 download for macWhen you're finished, click outside the chart, in the main body of the Word document. In Word, do Edit > Paste, or just ctrl-v.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. Do Edit > Copy, or just ctrl-c. Make sure it shows 8 hollow round markers on the edge. Insert Excel Spreadsheet Into Word Full Width OfAnd adjust the size of text within the chart in Excel.If you want a chart the full width of the page, set the paper size and margins in Excel to be the same as your Word document. But if you do so, the size of text in the chart (the chart title, axis titles and tick marks, or the legend) can end up either too small or too large.To solve this problem, make the chart in Excel about the same size as you want it to appear in Word. How to control the size of text in a chartWhen you paste a chart into a Word document, you can re-size it to suit your needs. For more information, see Is your image slipping? How to get your images to stand still.If you have a caption for your chart, and you want to make sure that the chart and the caption stay together, see How to keep a figure on the same page as its caption in Microsoft Word. Otherwise (that is, in most cases), your chart should be in-line. This controls the placement of your chart and how text flows around the chart.If you want text over the chart, behind the chart, or to wrap around the chart, then your chart needs to float. In Excel 2007, click the chart, then on the Format contextual tab, enter the size you need. Either method will display the Format Object dialog (Figure 3) where you can set the size of the chart. Or, hold down the Ctrl key and choose Format > Object. In Excel 2002 or 2003 hold down the Ctrl key and double-click the chart. Or, click the chart, then on the Format contextual tab, enter the size you need. Choose Size on the left menu to display the Size pane where you can enter the size for your chart. That displays the Format Chart Area dialog (Figure 4).
0 Comments
Leave a Reply. |
AuthorAimee ArchivesCategories |