Linking charts from one workbook/sheet to another workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Champlain - 17 Aug 2004 20:43 GMT

I want to be able to put a link into one workbook, that will reference/update
from a chart that was created in another workbook. No problem. However, I
have several charts in this workbook on sheet1 and I want to be able to pick
and choose which chart from this workbook/sheet I link to my other workbook.
I tried name ranges but that only brings in everything from sheet1 as opposed
the specific chart that I want. I'm trying to do this through Insert, Object
and browse to the file I want and then put the sheet/name range at the end of
the file name. Any suggestions would be greatly appreciated.

Reply to this Message

Bill Manville - 17 Aug 2004 23:39 GMT

> I want to be able to put a link into one workbook, that will reference/update
> from a chart that was created in another workbook. No problem. However, I
> have several charts in this workbook on sheet1 and I want to be able to pick
> and choose which chart from this workbook/sheet I link to my other workbook.

Not easy.
Here's how I thought I would do it:

- arrange each chart on sheet1 to sit exactly over a rectangular range of cells
- name those ranges of cells "Cht1", "Cht2" etc
- Select range Cht1
- Shift+Edit / Copy Picture
- activate the workbook which is to contain the linked version
- Edit / Paste
- In the formula bar type =[Book1.xls]Sheet1!Cht1
(adjusting book/sheet names as appropriate)
- repeat the last 5 steps for each other chart.

This works but it doesn't update the pictures unless both the source and
destination workbooks are open at the same time.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message