Multiple Excel Charts embedded in Powerpoint slides.

[Guest]

I have a large Excel worksheet with eight charts, each on a different tab.
Working from the one workbook, can I link individual charts from each tab to
individual PPT slides, or - my current solution - should I create eight
individual Excel files, each linked to a specific chart, then embed these
individual workbooks into separate PPT slides?

 

[Steve Rindsberg]

I have a large Excel worksheet with eight charts, each on a different tab.
Working from the one workbook, can I link individual charts from each tab to
individual PPT slides, or - my current solution - should I create eight
individual Excel files, each linked to a specific chart, then embed these
individual workbooks into separate PPT slides?

You're asking two different questions here (linking vs embedding and one XLS
file vs many).

If you embed any portion of an XLS into PPT, the entire contents of the XLS
gets embedded, so one big XLS with 8 charts would produce a larger PPT file
than 8 XLS files, one chart each. In addition, a user might activate the first
chart, change some data there, then move to a different chart in the same
temporarily activated workbook, change some data there and expect both charts
to update in PPT. Which won't happen.

On the whole, if embedding, I'd go with multiple XLS files, each with just the
data/chart needed, no more.

Linking is another story. If you want to be able to change the source XLS and
have the charts in PPT update, you need to link, not embed. Then it doesn't
matter whether you have one or many XLS files; I'd use one if only to keep
maintenance simple.

 

[Guest]

Hello:

Thank you for clarifying the question.
I would like to link the charts created in EXCEL to Powerpoint and have
Powerpoint update the charts everytime new data gets enered into EXCEL.
How do I ask Powerpoint to link a specific chart created in an EXCEL
workbook that contains more than just the one specific chart?
for example, I have Workbook 1, inside this book, I have 3 charts 1, b, c.
I want to link chart a in book 1 to be slide 1, chart b in book 1 in slide
2, and chart c in book 1 in slide 3 of Powerpoint. How do I do that?

 

[Steve Rindsberg]

Hello:

Thank you for clarifying the question.
I would like to link the charts created in EXCEL to Powerpoint and have
Powerpoint update the charts everytime new data gets enered into EXCEL.
How do I ask Powerpoint to link a specific chart created in an EXCEL
workbook that contains more than just the one specific chart?
for example, I have Workbook 1, inside this book, I have 3 charts 1, b, c.
I want to link chart a in book 1 to be slide 1, chart b in book 1 in slide
2, and chart c in book 1 in slide 3 of Powerpoint. How do I do that?

It only takes a step or two more than a regular copy/paste.

Select the chart in Excel
Switch to PowerPoint
Choose Edit, Paste Special and put a check next to "Link"

That's all there is to it.