Excel Charts in Word
 

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

Excel Charts in Word
 

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
_______


"Marc" wrote in message
...
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

Excel Charts in Word
 

Thanks,,,I will give that a shot.

Marc

"Jon Peltier" wrote:

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
_______


"Marc" wrote in message
...
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