ICT Skills for Principals

Import a chart to Microsoft Word (Intermediate level)

As a principal you will often find yourself writing reports in which numerical data such as budgets are included. You would ideally be processing that numerical data in a spreadsheet such as Microsoft Excel. You will want to include either the data or a graph in your report, which you are writing in a Microsoft Word document. You may also want the data to be updated every time you open the file in Microsoft Word. You will work in Microsoft Word and Microsoft Excel to import a chart from a spreadsheet into a word processor.

By the end of this task you could achieve the following outcomes:

- Display visual information from Microsoft Excel in Microsoft Word
- Ensure that data is updated every time you open Microsoft Word
- Update a linked graph so that the latest information is shown.
- Cite sources for your information using footnotes.

Import your own chart into your own document - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:

1.	Start Microsoft Word. See how »
2.	Type the text into Microsoft Word.
3.	Start Microsoft Excel. See how »
4.	Enter your data in a spreadsheet.
5.	Create a chart (graph) of the data. See how »
6.	Link the Microsoft Excel graph in Microsoft Word: You can link the Excel graph to Word so that changes made to the Excel graph automatically reflect in the Word document. See how »
7.	Insert footnotes for sources: In Microsoft Word, indicate references to your information sources at the bottom of each page. See how »
8.	Save your document: Save both your documents. See how »
9.	Update the graph at any time: Usually the graph updates when you open or print the word processor document.

Related scenarios

» Create a chart
» Write a report
» Create a budget