Latest posts by techwriter (see all)
- How to Avoid Repeating Words in a Headline - April 18, 2017
- Leveraging Multi-Function Printers With Document Imaging Software - April 10, 2017
- Understanding and Effectively Using Document Indexing in a Document Capture Solution - April 5, 2017
© 2011 Ugur Akinci
Here is a good way to create a MS Word 2007 chart that you may need to edit at some point in the future.
The KEY IDEA is this: create your chart in MS Excel 2007 and then copy-paste it into your Word document. That way, the chart will maintain a link to the Excel document. Anytime you update the Excel chart, your Word chart will be updated as well.
(Click images to enlarge them)
(1) Launch both your MS Word 2007 and MS Excel 2007.
(2) In Excel, create your data table.
(3) Select your data and then select INSERT tab from the ribbon and click on one of the many chart types available on the CHARTS pod. For this tutorial, I’ll just use the most simple 2-D LINE graphic style. Excel will automatically create your chart.
(4) At this point, make sure to SAVE your Excel document because Word needs to refer to this document for updates.
(5) Select your chart and from your HOME tab, COPY your chart to the Clipboard.
(6) Now switch to your Word document and PASTE the chart wherever you want.
In the LAYOUT tab, you can select Data Table > Show Data Table option to display your data right next to your chart as well. It’s up to you.
Here is the same Word chart also displaying its associated data table:
(7) Now whenever you update your data in the associated Excel sheet and save it, your Word chart will be updated automatically as well.
(8) To edit data and chart, right-click on your Word chart and select the Edit Data option to switch automatically to the Excel document. Save your edits to change your Word chart accordingly.
(9) Make sure to save both your Word and Excel files before closing them.