When you need to put an Excel chart in a Word document, but you don't want it to mess up your layout, try this trick: Use a table cell to position the chart in the right spot.
You want to place an Excel chart in the top-left corner of the first page of your Word document. However, you don't want to spend time adjusting it so that it doesn't interfere with the rest of the page formatting. One solution is to create a table cell as a placeholder for the chart in your Word document.
Follow these steps:
- Open your Word document and insert a 2-inch high and 3-inch wide table in the top-left corner of your page.
- With the cell selected, click the No Border tool to remove the borders from the cell.
- Open the Excel workbook that contains the chart and select it.
- Resize the chart object to 2 inches by 3 inches. (For Excel 2007, in the Chart Tools Format tab, enter the placeholder table cell's height of 2 inches and width of 3 inches in the chart's Height and Width boxes.)
- Select the chart area and press Ctrl + C.
- Click in the table cell in the Word document, choose Paste Special from the Edit menu, select a Picture option, and click OK. (In Word 2007, press Alt + Ctrl + V, choose Picture (PNG), and then click OK.)
- Right-click the chart, choose Format Picture, and click the Layout tab. Under Wrapping Style, select In Line With Text. (In Word 2007, right-click the chart, choose Text Wrapping, and then click In Line With Text.)
The chart will appear in the top-left corner of the page as shown here:
Miss an Excel tip?
Check out the Microsoft Excel archive and catch up on other Excel tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.