Help ! Beer if you can help....

[Charlie170602!]

I'll buy a pint for anyone who can helpsave me an endless amount of time copying and pasting excel charts ito powerpoint...the problem is

(1) When I copy and paste charts into powerpoint I originally went through the paste special, paste link function. However when I right click on the chart in powerpoint and "update links" the chart/graph goes absolutely massive across the whole slide - I then have to click on the slide and delete it....hence at the moment I'm copying and pasting in as a picture each time (which is hard work every month when you are doing 30+ graphs)

All I want to be able to do is set them up in powerpoint and just update links everymonth !

I have a number of charts per slide (between 1 and 6) not sure if this impacts - but they have to be there as this is the report format

i Will buy a pint for anyone who can help me solve this one !!


(2) As an aside what is the best way to get graphs into powerpoint from a seperate excel workbook ? Even when i copy in as pictures i still have to resize each and everyone of them once in powerpoint, are there any shortcuts to this?

Manythanks

 

[dave3009]

Forgive me if I'm wrong but creating charts in excel and copying them over to powerpoint seems the wrong thing to do. Why not insert the charts into powerpoint and then adjust it's source each month that'll save you copy/pasting anything.

Insert>>Chart (in Powerpoint)

 

[Charlie170602!]

Thanks....

Off the back of yoour response i've tried setting up the graphs in powerpoint ....but this is like pulling teeth, powerpoint keeps freezing and crashing. Sure the point in having a link function in powerpoint is to do just that - the real issue I have here is around the particular graph expanding across the whole slide when "update links" is clicked on

 

[wcaseyc]

What version of PP and excel are you using?