Help! How to add many excel charts into PowerPoint at once?

J

Joules

I am working on a project in which we need to be able to view 180+ charts
easily. I wanted to insert them into PowerPoint easily, but am having
trouble finding a way to do that.

Thanks!
 
W

Will.Cairns

Joules,
I do much the same and here is how get around it...
(1) My charts are all created within a macro and their size and
positions are designated on the worksheet (I choose to fix them to a
particular cell location always)
(2) After the macro creates all n-number of charts (you can play with
the sizes so the transfer to ppt still leaves them in a readable state)
I select the cells and hold [shift] while clicking on [Edit] -> [Copy
Picture].
(3) Go to your slide and [Paste Special] -> [Picture]

Much of my slide content is already created in Excel so that my charts
and other text (headings, etc.) are all pasted in one step.. this also
avoids the sometime problem of charts that get lost behind other ppt
content since the slide is one big picture.

HTH,
Will
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top