use existing table data and not get generic excel chart data

macropod · #1 09-07-2015, 06:54 PM

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.

canar · #2 09-08-2015, 07:48 AM

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.

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