Graphs pasted into word should update with Excel changes.

[joeW]

Is there no way of inserting an excel graph a linked object which is updated
to reflect changes both in graph formatting and in the source data in Excel?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...188&dg=microsoft.public.word.drawing.graphics

 

[CyberTaz]

Sure - Copy the chart, then in Word - Home Tab click the little triangle on
the Paste button, select Paste Special> Paste Link> MS Office Excel Chart
Object. Right-click the chart & select Update Link when necessary.

If you mean you want a link to both the chart & to the data it's based on
you have two choices:

a) Paste the data in as a separate Linked Object in the same way, or

b) Select the chart in Excel (before copying), on the Chart Tools Tab>
Layout Tab - Labels Group select one of the Data Table options to include
the data table in teh chart object. Then copy/paste as a link as above.

 

[Watergirl3]

I've made a word template with excel graphs. Now almost all them work except
one graph. With this one graph, all the data is there except the last data
point. If I go to edit the datasheet, the data point is there, its just not
showing up in the graph in the word doc. I've changed the axes, so the data
point should be showing up. Do you have a solution?