Dynamic Chart Export to PPT

[Saket Kumar]

Dear All,
I have creat a dynamic chart in excel, and i want to run them on ppt.
I tried to copy & paste but its not work.
For ur reference i have attached a workbook.

[ashishmehra2010]

Hi Saket,

You need to follow the below steps:

1) Open the Excelfile
2) Copy the chart area from excel file
3) Click on Home ribbon in Powerpoint
4) Click on Paste & then Paste Special
5) Select 2nd option as "Paste Link" & click on "Microsoft Excel Worksheet Object" (check the attached picture)
6) Click on Animations ribbon in Powerpoint
7) Select More which is right next to the corner of the lower right corner of the Animation group (check the attached picture)
8) Select OLE Action Verbs
9) Click on Edit & then ok
10) Double click on the chart in ppt & it will automatically take you to the Excel file. Now you can select the option from drop down list & any changes will get reflected in the ppt chart that is linked with excel.

I hope this will help you.

Regards,
AM