Link or Embed Excel Charts: MS Word
If an Excel chart already exists, it's a simple matter to link or embed one into an MS Word document. The techniques are similar to those for linking and embedding Excel worksheets by using the Paste Special command.
Documents dealing with numeric data can often bog you down in details, causing a reader to miss the main point. A well-placed chart can show at a glance the trend or relationship among the numbers. While you can create a chart from scratch in MS Word, you don't need to do so if the chart already exists in Excel.
Follow the steps below to link or embed an Excel chart into a Word document.
- Launch MS Word and Excel.
- Open both Word and Excel files.
- Switch to Word and place the insertion point where you want the charge to be inserted.
- Choose Edit | Paste Special to see the dialog box.
- Click Paste and Microsoft Excel Chart Object to embed, or click Paste Link to link the chart.
The chart appears as a picture within the document, surrounded by sizing handles to adjust it, and change the text wrapping to position it on the page so that text wraps around it. Double-click it to modify the contents of the chart using Excel, as with worksheets.
Don't just dump a charge into a document. Always label it as a Figure, Exhibit or Chart and refer to it specifically by name in the document.
Even if an Excel chart requires an entire page, don't just print it in Excel and insert the sheet between your report pages. Instead, insert the chart right into the document so the page numbering and headers and footers are consistent throughout. If necessary, change to landscape orientation to make a large chart.
You can find tips like this and many, many more in the Carol's Corner Office Tips and Tricks eBook. Click the link to download your copy today!
(c) Carol Bratt, all rights reserved. Used with permission. Duplication is forbidden without express consent of author. Visit Carol's web site to learn more tips like this one!
Free eBook: The Windows 7 Guide: From Newbies to Pros. In this 46 page guide you will be introduced to Windows 7 and what it has to offer. It will teach you about the new taskbar, how to resolve software compatibility issues, how to customize Windows Aero, and explain what the Windows 7 Libraries are all about. Also included: a detailed list of what software is included in Windows 7, and how easy networking is with Windows 7 along with other topics. The advice within this guide will help new users become acquainted with Windows 7 and can also help those who are on the fence about purchasing Windows 7 decide if it would be a good idea. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.