Linked Excel Charts/PowerPoint

[R Keegan]

Currently use Office 2000. I have an Excel workbook with
8 sheets; 4 data sheets which link to 4 different charts.
The charts needs to be inserted into PowerPoint. However,
I have discovered that PowerPoint doesn't like it when all
the charts that need to be linked are in the same
workbook. I have tried this several times and have
discovered that if I insert Chart 1, 2, 3, 4 onto
individual slides in PPT with links, close Excel, switch
to PPT, the last chart that was viewable on my screen when
I closed Excel (for example, chart 3) is the only chart
that appears in PPT, on all 4 slides. Chart 1, 2, 4 are
replaced with chart 3.

Does anyone have a solution? Or is it best to place each
chart in it's own Excel workbook?

 

[Steve Rindsberg]

Currently use Office 2000. I have an Excel workbook with
8 sheets; 4 data sheets which link to 4 different charts.
The charts needs to be inserted into PowerPoint. However,
I have discovered that PowerPoint doesn't like it when all
the charts that need to be linked are in the same
workbook. I have tried this several times and have
discovered that if I insert Chart 1, 2, 3, 4 onto
individual slides in PPT with links, close Excel, switch
to PPT, the last chart that was viewable on my screen when
I closed Excel (for example, chart 3) is the only chart
that appears in PPT, on all 4 slides. Chart 1, 2, 4 are
replaced with chart 3.

This sounds more like what normally happens with embedded data from Excel, not
linked. What *exact* steps did you follow to get the charts into PPT?

 

[Don]

I know I have had a similar issue when I
Insert>Object>Create from File.

I specify the Excel file but I do not get the option to
select a specific chart in the file - so whatever sheet
was on the screen last when saving the Excel file will be
what is displayed in PP when the link is updated.

I am familiar with creating a chart in PP and linking the
data from an Excel sheet into the Datasheet using Copy
and Paste Link but it would be nice to know if it is
possible to link multiple charts from Excel into PP with
the ability to specify different Charts/Worksheets.

I am using Office 2003.

Thanks.

 

[Kurt]

Don,
with www.take-off.as/datapoint you can link your powerpoint graph to any
datasource for automatic updating, no programming required.

regards,
Kurt

 

[Steve Rindsberg]

I know I have had a similar issue when I
Insert>Object>Create from File.

I'd expect so.

I am familiar with creating a chart in PP and linking the
data from an Excel sheet into the Datasheet using Copy
and Paste Link but it would be nice to know if it is
possible to link multiple charts from Excel into PP with
the ability to specify different Charts/Worksheets.

Sure. Copy from Excel, switch to PPT, choose Edit, PasteSpecial, put a check
next to Link. As many times as you like.

I have to admit that I haven't tried this *specifically* in Office 2003, but
it's worked this way in all prior versions as far as I'm aware.