Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2013, 01:03 PM
Boo Boo is offline chart in microsoft office word Windows XP chart in microsoft office word Office 2007
Novice
chart in microsoft office word
 
Join Date: Mar 2013
Posts: 9
Boo is on a distinguished road
Default chart in microsoft office word


By inserting a chart in a MS Word file, the data by default is in the workbook "chart in microsoft office word". Where is the "chart in microsoft office word?" Thanks
Reply With Quote
  #2  
Old 03-09-2013, 07:59 PM
macropod's Avatar
macropod macropod is offline chart in microsoft office word Windows 7 64bit chart in microsoft office word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Boo,

Right-click on the chart and choose 'Edit' to gain access to the data sheet underlying the chart.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-10-2013, 05:35 AM
Boo Boo is offline chart in microsoft office word Windows XP chart in microsoft office word Office 2007
Novice
chart in microsoft office word
 
Join Date: Mar 2013
Posts: 9
Boo is on a distinguished road
Default

Thanks, Paul. I am interested to find the location (drive/folder) of the Xls file where the data is stored. Thanks
Reply With Quote
  #4  
Old 03-10-2013, 01:06 PM
macropod's Avatar
macropod macropod is offline chart in microsoft office word Windows 7 64bit chart in microsoft office word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unless you originally sourced it from an external workbook, it's embedded in the Word document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-10-2013, 01:11 PM
Boo Boo is offline chart in microsoft office word Windows XP chart in microsoft office word Office 2007
Novice
chart in microsoft office word
 
Join Date: Mar 2013
Posts: 9
Boo is on a distinguished road
Default chart in microsoft office word

Thank you, Mr. Edstein. By trying to edit the data, and Excel file opens. Doesn't this indicate that there is a separate workbook saved somewhere? I am not sure that I understand what xls is embeded in doc means.
Reply With Quote
  #6  
Old 03-10-2013, 01:32 PM
macropod's Avatar
macropod macropod is offline chart in microsoft office word Windows 7 64bit chart in microsoft office word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

No, it means the worksheet is embedded in the document (ie it is a part of the document). Office has had this feature for at least 20 years.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 03-10-2013, 01:37 PM
Boo Boo is offline chart in microsoft office word Windows XP chart in microsoft office word Office 2007
Novice
chart in microsoft office word
 
Join Date: Mar 2013
Posts: 9
Boo is on a distinguished road
Default chart in microsoft office word

Thanks again, Mr. Edstein. Is there a link(s) that sheds light on this concept though it is 20 years old. At this point, I would educate my self a bit. Regards.
Reply With Quote
  #8  
Old 03-10-2013, 01:45 PM
macropod's Avatar
macropod macropod is offline chart in microsoft office word Windows 7 64bit chart in microsoft office word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See:
http://office.microsoft.com/en-us/wo...010120810.aspx
http://office.microsoft.com/en-gb/wo...010198874.aspx
Although these articles mainly concern copying/pasting charts from Excel, the same principles re embedding apply to charts created directly in Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 03-10-2013, 01:58 PM
Boo Boo is offline chart in microsoft office word Windows XP chart in microsoft office word Office 2007
Novice
chart in microsoft office word
 
Join Date: Mar 2013
Posts: 9
Boo is on a distinguished road
Default chart in microsoft office word

I looked at the two articles and now know where the data is. My understanding is that there is an xls sheet but hidden (i.e. embedded) in the doc file algorithm. In other words, no way to find it. I guess that is life (

Thanks so much for taking the time.

Best regards
Reply With Quote
  #10  
Old 03-10-2013, 02:08 PM
macropod's Avatar
macropod macropod is offline chart in microsoft office word Windows 7 64bit chart in microsoft office word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Boo View Post
In other words, no way to find it. I guess that is life
Not if you're looking for an external file.

If you see a file with an object like a chart or a worksheet and the file doesn't have any links to an external file, you know the object is embedded, rather than linked. That being the case, you can find the data in the Word document by opening the embedded object itself.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 03-10-2013, 02:15 PM
Boo Boo is offline chart in microsoft office word Windows XP chart in microsoft office word Office 2007
Novice
chart in microsoft office word
 
Join Date: Mar 2013
Posts: 9
Boo is on a distinguished road
Default chart in microsoft office word

In life, any thing is "obvious" IF and WHEN we understand it. After your replies, I am able to follow your comments. I am comfortable with the linked options.

Thanks so much for all your help. We never know, we may meet again on the cyber highway.

Best regards.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
chart in microsoft office word Word 2007: How to get rid of "Microsoft Office Word Compatibility Checker" harrasalog wornways Word 2 11-24-2014 07:37 AM
option Paste special...as 'Microsoft Excel Chart Object' NOT available Intruder PowerPoint 0 12-24-2010 06:28 AM
Microsoft Office Davva Outlook 0 12-04-2009 08:38 AM
chart in microsoft office word I dont have Microsoft Office? JasonKoltai Office 1 09-26-2009 05:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


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