Excel and Word Integration
This week we will look at how you can include data from one Office Application in another. The most common link is to embed Excel information into a Word document.I will start by using our basic chart excel spreadsheet from a few weeks back. It looks like this.
Create a simple Chart - I have used a bar chart. My Chart and Spreadsheet look like this
Save the file.
The next stage is to create a document. For the sake of this exercise, mine will be pretty basic.
Save the Document.
Go back to the spreadsheet and Select and Copy (Ctrl-C) the Chart.
To place this chart in your Document, you want to do a Paste Link. You could do a straight Paste, but it means that your document will not be updated if data in the spreadsheet changes.
What we want to do is to link the data in our document with the source data, which is our spreadsheet. Each time you load the document, it will check to see if there is an update.
Save and close the document.
Go back to the spreadsheet and make a change to the data. I increased the National Proposed number to 40. The chart is updated as soon as the change is made.
Save and close the spreadsheet.
Open up the document! If you have created the link correctly, you should get a dialog box similar to the one below
