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: Getting Started: Your Guide to Windows 8. Windows 8 is arguably Microsoft's most daring Windows Operating system to date. Featuring an unusual tile-based Start screen that's optimized for touchscreen devices, Windows 8 is now available on all new computers, laptops and ultrabooks, and hybrid tablets. Whichever device you use Windows 8 on, you'll need to know a few things. First, how are you going to get the data from your current operating system to the new one? Second, you'll probably be wondering where Windows desktop has gone. Finally, you might be wondering: why did Microsoft remove the Start menu? This eBook answers all those questions, and more. 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.