Integrating office applications/Linking and embedding/Integrating charts

From WikiEducator
Jump to: navigation, search
OtagoPoly Logo S.png




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.



OP icon activity.gif

Activity

  1. Open word and create a new blank document.
  2. Open your spreadsheet Steeplechase_results.xlsx
  3. Using the columns for rabbit name, high jump and long jump, create a clustered column chart as an object in your sheet. Move the legend to underneath the chart and add a chart title above the chart. You should end up with something like this:

    Ioa-jumpschart.png

  4. Select the chart so you can see the chart border:

    Ioa-chartborder.png

  5. Copy the chart.
  6. Switch to your word document and paste the chart into your document.
  7. Save the Excel file and the word file.





OP icon exclamation.gif

Please note

Remember that if we want to change an embedded chart (for example to change the colour scheme, or if the data has changed) we need to do this in Excel, and re-copy and paste back into word.




Linking a chart in Word

We can link to the chart to ensure it updates dynamically when the spreadsheet data changes.



OP icon activity.gif

Activity

  1. Open word and create a new blank document.
  2. Open your spreadsheet Steeplechase_results.xlsx
  3. We will reuse the chart we created for the previous exercise. Select the chart. Copy.
  4. Go to your word document. Choose paste special. Make sure you choose Micosoft Excel Chart Object from the menu and select Paste Link.

    Ioa-pastelink2.png

  5. Save as Rabbits_3.docx.




Ioa-pastedlink.png


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:

Ioa-change3.png



OP icon activity.gif

Activity

  1. In the spreadsheet Steeplechase_results.xlsx change J Jones’s results to what is given above. Right away you should see the chart in the sheet change. Save your chart.
  2. Go back to your document rabbit_3.docx. The chart in the sheet should have also changed:

    Ioa-change4.png

  3. Print the Document. Save your document and close word.





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



OP icon activity.gif

Activity

  1. Click on the linked chart in your document – you should see a new tab called Chart Tools appear. This is exactly like the chart tools tab in Excel.

    Ioa-charttools.png

  2. Choose a grey scale colour scheme from the chart styles. There should be an obvious difference between the two columns as in the picture above.
  3. Click in the axis with the rabbit names. A box with selection handles will appear. Go to Home ⇒ Font group and change the font size to 12 points. Print your document. Save and close word.





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.