Importing Multiple Excel Charts

[Squid]

I have created an Excel workbook that contains over 100
charts. Now I want to import these charts into
powerpoint. What would be the most efficient way to do
this?

Thanks

 

[Kathryn Jacobs]

That depends on your answer to a few questions:
1) Which version of PowerPoint?
2) Do you need the data for the charts or just the charts themselves?
3) How much animation are you planning to do on the charts? Can they be just
jpegs, or do they need to be able to be animated by series, etc.?

--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Guest]

-----Original Message-----
I have created an Excel workbook that contains over 100
charts. Now I want to import these charts into
powerpoint. What would be the most efficient way to do
this?

Thanks
.

 

[Squid]

1. Powerpoint XP
2. Just the charts (one workbook that contains all the
charts is linked to another workbook that contains all the
data)
3. No animation will be used.

 

[Kathryn Jacobs]

Okay. Then what I would do is save the charts as graphics from Excel. I
thought there was a way to save all of the charts from a single file as
graphics, but I am not finding it right now. Maybe someone else will have an
idea on that part.

Once you have all the charts as graphics, use either the Photo Album tool or
one of the other multiple graphic insert tools to pull them all into your
presentation at once. Information on pulling all the graphics in at once is
found on the PPT FAQ at:
Batch Insert a folder full of pictures, one per slide
http://www.rdpslides.com/pptfaq/FAQ00352.htm
(My preference is the Image Importer. I like the way it works and it is easy
to use.)

--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Squid]

Hi Kathryn:

Last question...
My user just told me she has 240 charts (and she wonders
why her computer is running slow). What is the best or
most efficient way for her to convert those excel charts
into graphic files?

Thanks again
Mike

 

[Kathryn Jacobs]

Mike,
I have two options for you:
1) If you save the Excel file as HTML, it will create image files of each
chart. They will be named image001.gif, image002.gif, etc.
2) If you want to be able to do the saves to your own names, you can do that
with VBA. I found a thread on one of the Excel boards that has the code. You
can find it at:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]
(If that wordwraps, try this tinyURL version: http://tinyurl.com/ypehr )

What do you think? Will one of those two options work?
--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Tushar Mehta]

You might want to check code I posted some time back:

http://www.google.com/groups?selm=MPG.17b0e6e69133691e98a700%
40msnews.microsoft.com

and

http://www.google.com/groups?selm=MPG.17b8b95b65cc151798a728
@msnews.microsoft.com

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions