Excel Charts in Word

[Marc]

I have a word report I need to do every month. The data and charts are in
excel and the data changes monthly. How do I get the excel charts linked
into a word document so that when I enter the new data in the excel
spreadsheet that is automaitically updated in the report in the word docuemnt?

Thanks

 

[Jon Peltier]

Copy the Excel chart. In Word, use Edit menu > Paste Special, and select the
Paste Link option.

- Jon

 

[Marc]

Thanks,,,I will give that a shot.

Marc

Copy the Excel chart. In Word, use Edit menu > Paste Special, and select the
Paste Link option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______