Microsoft Office Forums use existing table data and not get generic excel chart data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2015, 04:47 PM
canar canar is offline use existing table data and not get generic excel chart data Windows 10 use existing table data and not get generic excel chart data Office 2010 64bit
Novice
use existing table data and not get generic excel chart data
 
Join Date: Sep 2015
Posts: 5
canar is on a distinguished road
Default use existing table data and not get generic excel chart data

1) Existing Word 2010 table
2) Select INSERET then CHART (Excel) creates a chart using generic data
3) How can I get the chart to automatically show the existing table data as the chart instead of the generic useless data. It seems rather pointless to have a sample of not needed data.
4) Is there a way to create the chart without having to manually copy the existing table data into Excel.
5) This seems like it should be a basic intergration between a MS Word table and a MS Excel chart format.


6) I don't want to take existing data from an Excel sheet since teh table data is already there in Word.
Reply With Quote
  #2  
Old 09-07-2015, 06:54 PM
macropod's Avatar
macropod macropod is online now use existing table data and not get generic excel chart data Windows 7 64bit use existing table data and not get generic excel chart data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,670
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

Charts in Word rely on functionality from Excel - a Word table can't be used directly. After creating the chart based on the generic table, you can double- click on it and paste your table data into the underlying Excel worksheet.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-08-2015, 07:48 AM
canar canar is offline use existing table data and not get generic excel chart data Windows 10 use existing table data and not get generic excel chart data Office 2010 64bit
Novice
use existing table data and not get generic excel chart data
 
Join Date: Sep 2015
Posts: 5
canar is on a distinguished road
Default

Thanks Paul.

I knew about d/clicking and pasting it into the Excel sheet but I was hoping there was a way for Excel to automatically paste or pull the data from the Word table directly. Seems to me that the two programs should work together better than having an extra copy / paste step. Even If I had to adjust the excel chart after it populated directly from word .... but I guess it can't more's the pity. Got to love M/soft.
Reply With Quote
  #4  
Old 09-08-2015, 03:36 PM
macropod's Avatar
macropod macropod is online now use existing table data and not get generic excel chart data Windows 7 64bit use existing table data and not get generic excel chart data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,670
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

It could be done programmatically (i.e. using a macro), but the functionality isn't built in.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
use existing table data and not get generic excel chart data Extract Excel Data from Chart in Word cillianmccolgan Word 1 08-15-2014 01:42 AM
sending data from UserForm of existing excel file to a new excel file saltlakebuffalo Excel Programming 0 02-13-2014 10:55 PM
Copy Excel data into an existing Word Table JJG Word 1 12-18-2013 05:41 PM
use existing table data and not get generic excel chart data How to dynamically link imbedded Excel chart with source data from Word TBoz Excel 1 07-06-2012 05:53 PM
use existing table data and not get generic excel chart data Push data automatically from Acess or Excel to create a Gantt chart in Project GST2212 Project 3 07-06-2012 12:52 PM


All times are GMT -7. The time now is 04:30 PM.


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