Linking Chart to table in a Word Document

[DataHugger]

I wish to create a template. This template with have charts linked to an excel table. I know I can create excel charts and excel table directly in word. Can I link the Chart that is in the document to the table that is in the document. I wish to do it this way so I can copy the data from a table put it in the excel table on the word document and have the charts change accordingly. I think this can be done. Is my assumption right?

How do I do this?

And if you don't want to answer that where should I look for information on doing this? ex. I look in the word help files, but maybe not in the right places. Any other suggestions?

 

[macropod]

Hi DataHugger,

When you paste an Excel Chart into Word, you also get the underlying workbook and its data. All you need to do, then, is to open up the chart object in Word, select the appropriate data tab and replace the source data for the chart with the standard Excel external link data pointing to the source in the original workbook. All other sheets, rows & columns can then be deleted (so as to minimise the overheads).

You will probably find, though, that you'll have to open & close the embedded chart object in Word to get it to update in the light of changes to the source data.

Cheers

 

[DataHugger]

So basically if I wish to have a copy of the chart and the table in the same document I should like import chart from excel and copy the table and leave them linked in the original doc?

Using VBA can I change the table that the chart links to?
ex. I have a page that Link to one table. I make a copy of that page and link it to another table. Is that possible?

 

[macropod]

Hi DataHugger,

What I was suggesting is that you do a simple copy & paste of the Excel Chart into the word document. Then, double click the embedded chart. This will open up the whole Excel object, both the Chart and all worksheets. Delete any worksheets and rows/columns that aren't used directly by the chart. Then, with the remaining cells, insert a formula along the lines of:
='C:\Investments\Property\[Finances.xls]Sheet1'!A1
pointing back to the original Workbook & worksheet data upon which the chart is based.

If you also want to have a table with this data embedded in the word document, you have two options:
1. copy just the area of the workbook that you're interested in and paste it into the Word document as a linked object, or
2. copy the embedded chart object and delete the chart from the copy.

Cheers