Using powerpoint to insert graphs from Excel

[Keroro6666]

Hi there

Please assist me with the following automating task using Excel 2010...

I need to write a macro, from my current workbook that contains the data, that will:
- copy the data from my current sheet
- open powerpoint
- use PowerPoint's Insert chart function as seen on the ribbon (choose bar graph) and upon which an excel sheet will appear to contain data for the particular chart
- paste the data from current worksheet into the sheet that was opened by powerpoint as values (once the data has been pasted, the chart should have formed it's shape)
- and return back to my excel workbook.

Ideally, at the end of the day, this automation should go thru each of my worksheets to get data and insert charts via PowerPoint which should just the loop through the above tasks.

However I am already having trouble without the looping and would like to know for now how to tell PowerPoint to implement it's insert chart function and paste my data using VBA .


I know that a potential solution is to make graphs inside excel and paste them into PowerPoint, but that is precisely what I am trying to avoid because I don't want to depend too much on the linking of data between PowerPoint and Excel.

Please please help!

Thanks