PDA

View Full Version : Excel Pivots to PowerPoint



Endorphin
10-27-2008, 11:16 AM
Good evening all,

I have an Excel work book which contains 5 Pivot tables and 10 charts, the pivot tables vary in size depending on the week/month.
Now for the difficult bit. :banghead:
I am trying to find a way, from one button press to create a PowerPoint presentation using all the above data, save it and email this to 5-10 other people.
I think I have the email bit solved but not really sure how to get the pivot tables across automatically while keeping their size within the slide limits.

Any Ideas. :dunno

Neil