Integrating office applications/Linking and embedding/Integrating charts

Embedding a chart into Word
Adding an Excel chart into Word is very similar to adding a table of data. We copy the highlighted table and paste it into word.

Linking a chart in Word
We can link to the chart to ensure it updates dynamically when the spreadsheet data changes.



Demonstrating the chart link.
''The world of rabbit steeple chasing is highly competitive. It turns out that one of the club members has been involved in a bunny doping scandal! You are to amend the results for J Jones’s rabbits. A 50cm penalty is to be put against both his rabbits.''

The new results are:



Formatting a linked chart in Word
Open the document you created in the previous activity with the linked chart in it.

We are going to make some changes to the chart:


 * We’re going to change the colour scheme, as currently when printed in black and white we can’t distinguish between the grays
 * We are going to change the text size of the rabbit names

Manually updating linked objects
Remember that you might have to “refresh” your word document in order to update changes that you have made:


 * 1) Right click on the object in Word - usually this would be a table. A context-sensitive menu will appear.
 * 2) Click on Update Link. This will force Word to manually update the table.