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