I have a workbook that creates a number of charts which I update every month. It would be very useful if I were able to copy and paste these charts into slides. However the way the charts work means I would need to see three charts grouped together on each slide, rather a single chart on a single slide. I'm never much good at explaining these things so hopefully the below might explain it better:
In the Excel Sheet I have
Chart1, Chart2 and Chart3, next to each other.
Chart4, Chart5 and Chart6, again next to each other.
Chart7, Chart8 and Chart9, also next to each other, and so on.
On the Excel sheet they make sense next to each other. One is actual performance against last year, one is a long term trend line, the final one if a plan against actual in year. In the Excel sheet I have set up the sheet so these charts sit next to each other and can be viewed easily. In the Powerpoint presentation I need to see them in the same way and the only way I can think to do that is to group them as below:
Chart1 + Chart2 + Chart3 grouped = Object1
Chart4 + Chart5 + Chart6 grouped = Object2
Chart7 + Chart8 + Chart9 grouped = Object3
How can I write some code that copies the objects, (I will group them in Excel if necessary), and pastes them into a single slide on Powerpoint for each object - i.e. - Slide1 contains Object1, Slide 2 contains Object2, Slide3 contains Object3 etc..