Microsoft Office Forums How to dynamically link imbedded Excel chart with source data from Word

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2012, 06:31 PM
TBoz TBoz is offline How to dynamically link imbedded Excel chart with source data from Word Windows XP How to dynamically link imbedded Excel chart with source data from Word Office 2007
Novice
How to dynamically link imbedded Excel chart with source data from Word
 
Join Date: Jul 2012
Posts: 1
TBoz is on a distinguished road
Default How to dynamically link imbedded Excel chart with source data from Word

I have a Word 2007 document with an imbedded Excel chart object. I would like to link the Excel chart graph to data in the Word document. Another words, when I manually change a data value in the Word document, the imbedded Excel chart object (in the same Word document) will dynamically update. How do I achieve this?



- Using MS Office 2007
- Windows XP SP3
- Chose simple column chart type with one series of bars
- Tried copying with Paste Special but Paste Link is grayed out

Please help. Seems like a simple thing to do but I can't seem to find a way to pull in the data dynamically. Thanks.
Reply With Quote
  #2  
Old 07-06-2012, 05:53 PM
macropod's Avatar
macropod macropod is offline How to dynamically link imbedded Excel chart with source data from Word Windows 7 64bit How to dynamically link imbedded Excel chart with source data from Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,605
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

If your last 'copy' action prior to switching to Word was the chart object, I can't see why the 'Paste Link' option would be greyed out - it isn't when I do it.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to dynamically link imbedded Excel chart with source data from Word drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM
How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM
How to dynamically link imbedded Excel chart with source data from Word How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM
How to dynamically link imbedded Excel chart with source data from Word Link data from embedded excel sheet rwbarrett Word 1 05-27-2011 02:05 AM


All times are GMT -7. The time now is 06:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft