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 guide: Windows 8 Cheat Sheet: Keyboard Shortcuts. Microsoft Windows has always had some fantastic time-saving keyboard shortcuts designed to make our lives easier. For example: CTRL-X will cut text or objects, and CTRL-V will paste them. (Of course, you can use your mouse to achieve the same thing, but it requires clicking and fumbling through menus, which can be a huge time waster if you cut and paste 50+ times a day). With Windows 8, Microsoft has added many new keyboard shortcuts to their operating system; unfortunately, it's a bit of a learning curve. That's where the Windows 8 keyboard shortcuts cheat sheet comes in! Simply download the guide and reference it when you need to. You'll save a ton of time using your keyboard, rather than reaching for the mouse and flipping through oodles of menus trying to find what you're looking for. Share and enjoy! Click here to download this guide now! Note: this guide 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.