A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking Several Charts to a PowerPoint Presentation



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2004, 04:57 PM
JRPK
external usenet poster
 
Posts: n/a
Default Linking Several Charts to a PowerPoint Presentation

I'm having a problem regarding linking several Excel charts and tables
from a single Excel file into a PowerPoint Presentation.
Example:
I create a chart on tab #1 of the Excel file and paste-link it into
slide #1 in the PowerPoint file.
Then I copy the tab (and call it tab #2) in the same Excel file but
change the data and paste link the chart on tab #2 of the Excel file
into slide #2 in the PowerPoint file.
Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . .

Now lets say I update the data in the chart on Tab #2 in the Excel
file and go to PowerPoint to update it.

It will now convert all the charts in the PowerPoint file to the chart
on tab #2. It seems when I update the links, whatever tab is showing
(in this case the chart on tab # 2) on screen in the Excel file will
then be reflected in every link in the PowerPoint file. It's as if it
ignores the links to the designated spread sheets and simply looks to
the Excel file to see what it currently looks like.

Am I doing something wrong? Do I actually have to create and format a
brand new chart on a brand new tab everytime I want to link multiple
charts. Copying tabs but individually linking them seems like it
should work.

If it's of any help, both PowerPoint and Excel are XP versions.

Any help would be greatly appreciated.

Thanks!

JRPK
  #2  
Old February 5th, 2004, 08:17 PM
Bruce Yanulavich
external usenet poster
 
Posts: n/a
Default Linking Several Charts to a PowerPoint Presentation

I had the same problem.
There is no simple answer.
I had to make a separate excel file for each chart.
That way it look at the top sheet for each specific chart.
You can't do it in one workbook.


"JRPK" wrote in message
om...
I'm having a problem regarding linking several Excel charts and tables
from a single Excel file into a PowerPoint Presentation.
Example:
I create a chart on tab #1 of the Excel file and paste-link it into
slide #1 in the PowerPoint file.
Then I copy the tab (and call it tab #2) in the same Excel file but
change the data and paste link the chart on tab #2 of the Excel file
into slide #2 in the PowerPoint file.
Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . .

Now lets say I update the data in the chart on Tab #2 in the Excel
file and go to PowerPoint to update it.

It will now convert all the charts in the PowerPoint file to the chart
on tab #2. It seems when I update the links, whatever tab is showing
(in this case the chart on tab # 2) on screen in the Excel file will
then be reflected in every link in the PowerPoint file. It's as if it
ignores the links to the designated spread sheets and simply looks to
the Excel file to see what it currently looks like.

Am I doing something wrong? Do I actually have to create and format a
brand new chart on a brand new tab everytime I want to link multiple
charts. Copying tabs but individually linking them seems like it
should work.

If it's of any help, both PowerPoint and Excel are XP versions.

Any help would be greatly appreciated.

Thanks!

JRPK



  #3  
Old February 6th, 2004, 02:41 PM
Kurt
external usenet poster
 
Posts: n/a
Default Linking Several Charts to a PowerPoint Presentation

Hi,
With www.take-off.as/datapoint you can create live graphs linked to excel
data (and databases) in a PowerPoint presentation.
Kurt

"Bruce Yanulavich" wrote in message
...
I had the same problem.
There is no simple answer.
I had to make a separate excel file for each chart.
That way it look at the top sheet for each specific chart.
You can't do it in one workbook.


"JRPK" wrote in message
om...
I'm having a problem regarding linking several Excel charts and tables
from a single Excel file into a PowerPoint Presentation.
Example:
I create a chart on tab #1 of the Excel file and paste-link it into
slide #1 in the PowerPoint file.
Then I copy the tab (and call it tab #2) in the same Excel file but
change the data and paste link the chart on tab #2 of the Excel file
into slide #2 in the PowerPoint file.
Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . .

Now lets say I update the data in the chart on Tab #2 in the Excel
file and go to PowerPoint to update it.

It will now convert all the charts in the PowerPoint file to the chart
on tab #2. It seems when I update the links, whatever tab is showing
(in this case the chart on tab # 2) on screen in the Excel file will
then be reflected in every link in the PowerPoint file. It's as if it
ignores the links to the designated spread sheets and simply looks to
the Excel file to see what it currently looks like.

Am I doing something wrong? Do I actually have to create and format a
brand new chart on a brand new tab everytime I want to link multiple
charts. Copying tabs but individually linking them seems like it
should work.

If it's of any help, both PowerPoint and Excel are XP versions.

Any help would be greatly appreciated.

Thanks!

JRPK





  #4  
Old April 2nd, 2005, 10:02 PM
Rich Rich is offline
Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 3
Default

Linking PowerPoint data into Excel has many limitations. A good tool that may work for you is xpport. It reads your print areas and therefore can copy multiple tables and charts from multiple sheets in your xls file to PowerPoint with a single click. Let me know how it works for you.
Rich

Quote:
Originally Posted by JRPK
I'm having a problem regarding linking several Excel charts and tables
from a single Excel file into a PowerPoint Presentation.
Example:
I create a chart on tab #1 of the Excel file and paste-link it into
slide #1 in the PowerPoint file.
Then I copy the tab (and call it tab #2) in the same Excel file but
change the data and paste link the chart on tab #2 of the Excel file
into slide #2 in the PowerPoint file.
Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . .

Now lets say I update the data in the chart on Tab #2 in the Excel
file and go to PowerPoint to update it.

It will now convert all the charts in the PowerPoint file to the chart
on tab #2. It seems when I update the links, whatever tab is showing
(in this case the chart on tab # 2) on screen in the Excel file will
then be reflected in every link in the PowerPoint file. It's as if it
ignores the links to the designated spread sheets and simply looks to
the Excel file to see what it currently looks like.

Am I doing something wrong? Do I actually have to create and format a
brand new chart on a brand new tab everytime I want to link multiple
charts. Copying tabs but individually linking them seems like it
should work.

If it's of any help, both PowerPoint and Excel are XP versions.

Any help would be greatly appreciated.

Thanks!

JRPK
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.