Inserting a chart
1. Select the data to use, then use Excel’s chart wizard to choose the type and
layout of the graph
2. Choose the Type of graph
3. Sharing data
Basic copy and paste
Click anywhere on the outside of the chart – you will see black handles appear around
the edge of the chart • Click the copy icon, or press CTRL+C • Start MS Word • Choose
paste – CTRL+V
The problem with basic copy and paste • Go back to Excel without closing Word
(use the tabs at the bottom of the screen, or hold down the ALT key and press TAB to
cycle through available windows) • Use the tabs within Excel to go back to your data •
Change one of the values that appears in your chart • Have a look at the chart within
Excel – that value has changed • Now go back to Word – the chart has not been
changed
Linked copy and paste • Copy the chart in Excel in the same way • Go back to Word
• Click to place the cursor under the first chart (you may need to press return to create
a new line – click to the right of the existing chart and then press return if so) • This
time, choose Paste special (you may need to click the double arrow at the bottom of
the menu to show it the first time)
Select “Paste link” • As the text at the bottom of the window says, “changes to the
source file will be reflected in your document” • Click OK Again the chart is inserted.
Now, though, when you go back to Excel and change a value, that change is
represented both in Excel’s chart and Word’s (try it to check… - you may need to save
and close the document in Word and then open it again to see the update)
docsity.com
