Charlie170602!
New Member
- Joined
- Dec 1, 2009
- Messages
- 3
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
(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