If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking charts from one workbook/sheet to another workbook
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. |
#2
|
|||
|
|||
Champlain wrote:
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Several Charts to a PowerPoint Presentation | JRPK | Links and Linking | 3 | April 2nd, 2005 10:02 PM |
Linking Workbook Data | Andy Sandford | Worksheet Functions | 0 | February 19th, 2004 11:40 PM |
Linking Workbook Cells | Paul | Worksheet Functions | 0 | December 12th, 2003 08:56 AM |
Charts print incorrectly in multiple sheet workbook | Bryan G. \(Indianapolis\) | Charts and Charting | 0 | November 14th, 2003 01:29 PM |
Maximum charts or data series in workbook | [email protected] | Charts and Charting | 2 | October 31st, 2003 04:30 AM |