#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
It could be done programmatically (i.e. using a macro), but the functionality isn't built in.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
How to dynamically link imbedded Excel chart with source data from Word | TBoz | Excel | 1 | 07-06-2012 05:53 PM |
Push data automatically from Acess or Excel to create a Gantt chart in Project | GST2212 | Project | 3 | 07-06-2012 12:52 PM |