MrExcel Publishing
Your One Stop for Excel Tips & Solutions

link Excel graphs to Word


Posted by Christine on January 02, 2002 1:00 PM

I use Windows 2000. How do I paste a graph from Excel into Word AND maintain a link so that further changes in Excel will be portrayed in the Word graph? Help! I've been at this for hours! Also, how do I size the graph once in Word??


Posted by Adam S. on January 02, 2002 3:08 PM

Have you tried Edit\Paste Special\paste link?

From Excel

click on the chart
edit\copy

go to your Word file
edit\paste special\check Paste Link.

The 2 charts should now be linked. (you may need to hit F9 to update occasionally).

Hope that helps
Adam S.