3. In Word, Position the cursor in the document where you'd like to put the graph.
4. Click Edit | Paste Special
The following box will appear:
5. Select the option Paste Link. This will place the picture in your document, but also maintain a link to the Excel Graph.
Any changes that are made to the Excel spreadsheet will reflect in the Word document each time it is opened. The Excel sheet must be saved before Word will see any changes.
If open the document in Word and want to check that this is the latest version of the graph, right-click the graph in word, and select Update Link.
The
Educators' Network
Copyright
SchoolNet SA and
SCOPE. All Rights Reserved.