Linking Excel to PowerPoint

[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

 

[Jon Peltier]

You need to make a new chart for each link in PowerPoint. Every time you
change the chart to link it to another PowerPoint graphic, you're
changing the chart, right, and the link updater notices that the chart
has changed, and changes it everywhere it exists in the presentation.

- Jon

 

[JRPK]

That isn't the situation I'm dealing with. I DO have a seperate chart
for each slide. Mabe I wasn't clear in my explanation, I'll explain
the situation again. . .

I created one chart in Excel and copy-linked that one chart into a
PowerPoint slide. So far no problem.
Then I copied the entire Excel tab (data and chart) and pasted it
wihtin in that same workbook as a NEW Excel tab. I then chaged the
data in the new tab (which updated the chart on the new tab) and then
copy/linked the new chart from that new tab to a new (second)
PowerPoint slide...I reapeated this procedure several times.

BUT when I went into ANY chart in the Excel file (not just the
original chart) and edited that chart, then when back to PowerPoint
and updated the links, it changed ALL the charts that were paste-liked
into the PowerPoint file to that one chart. So esentially I now had 5
slides with the exact same chart on it.

It did not acknowledge that each chart in the Excel file was
exclusively linked to a seperate slide in PowerPoint. It just treated
the links like they were all linked to whatever the most recently
edited or "open" tab on the Excel Chart was.

Does that make sense?

Thanks

JRPK

 

[Jon Peltier]

Well, that is strange behavior. I just tried to reproduce it (Office 97)
and couldn't: the links all worked as expected. What do you see when you
go to Links on PowerPoint's Edit menu? Are all of the charts represented
in the list?

- Jon

 

[Jim Santa Barbara]

I have a slightly different question regarding linking Powerpoint and
Excel. I need to move data from Excel to Powerpoint charts, and I am
wondering if this can be "automated" to a certain extent to alleviate
some of the tedium of the job.


I need to take data from Excel and put it in Powerpoint charts, and in
a particular chart template. I don't want to make the chart in Excel
and move it to Powerpoint. I do this on a very regular basis, and the
data I start with is in a very similar format every time, and the
charts I import to are in a similar format every time as well. Is
there some sort of Macro that might do this?

I don't know if my question is clear, but any help you can give me
would be greatly appreciated (even if only to tell me "Yes/No" this
is/is not possible). Thanks!

 

[Jon Peltier]

Try this article:

GRAPH2000: VBA: How to Paste New Excel Data into an Existing Graph
(267974) - This article provides sample Visual Basic for Applications
(VBA) code that takes a range of cells from a Microsoft Excel 2000
worksheet and pastes the data into a Microsoft Graph 2000 object inside
another Microsoft Office 2000 program...
http://support.microsoft.com/default.aspx?scid=kb;en-us;267974

- Jon