PC Review


Reply
Thread Tools Rate Thread

Link a chart from another Excel file

 
 
=?Utf-8?B?QW5keQ==?=
Guest
Posts: n/a
 
      10th Oct 2006
I can't figure out how to paste a chart (with data I guess) into another
Excel file so that it's linked. I'm doing it in Excel 2000. Can anyone
help? thanks.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SEVL?=
Guest
Posts: n/a
 
      10th Oct 2006
Hi Andy:
I dont have XL2000 (but 2003). You can Copy and "Paste Special" [select:
Paste as Link] from Excel to Word, and likewise from Word to Excel, but not
from Excel workbook A to Excel workbook B weirdly enough. However, I tested
it by copying and pasting as link the chart from Excel to Word and then from
Word to a new Excel workbook (again copy/paste special, selecting "paste as
link"). Now if I change the numbers in my first Excel sheet, the chart
updates in BOTH Excel workbooks, amazingly (and also in Word, but who cares).
So I guess it's worth to try this workaround in Excel 2000.
HTH,
GL,
Henk

"Andy" wrote:

> I can't figure out how to paste a chart (with data I guess) into another
> Excel file so that it's linked. I'm doing it in Excel 2000. Can anyone
> help? thanks.

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      13th Oct 2006
Copy the chart from one workbook, paste it into the other, and it will
remain linked to the original workbook.

If you mean, how do you link it to the new workbook, here's what I answered
to a post from a couple days ago:

Re: Can a copy of a chart remain "live"


The charts are live, but they are still linked to the original data. You
could go through the Source Data dialog (Chart menu) to update the links to
the new data, but if the data sheets have the same layout, it is easier to
copy the whole sheet, including data and chart. This way, the chart is
linked to the data on its sheet. Then paste new data over the old and the
chart will update accordingly.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I can't figure out how to paste a chart (with data I guess) into another
> Excel file so that it's linked. I'm doing it in Excel 2000. Can anyone
> help? thanks.



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Microsoft Excel Charting 17 12th May 2010 06:51 PM
Excel Link to another Excel file and formulas RICK Microsoft Excel Discussion 2 24th Jan 2008 12:20 AM
Excel Chart-data references link another worksheet in same workboo =?Utf-8?B?V2FuZGEgSG91c2U=?= Microsoft Excel Misc 0 25th Jul 2007 03:40 PM
Link to file using data from another file in link to Harwardj Microsoft Excel New Users 4 8th Nov 2006 11:45 AM
copying excel chart formats from one chart to another nfrodsham@gmail.com Microsoft Excel Misc 0 31st Aug 2005 02:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:14 AM.