Im using excel 2010 and have graphs/charts in excel sheet and needs to bring it in Powerpoint by automated script or click of a button? How to do in VBA script/macro?
BAB
1To insert and link a selection of data from a saved Excel spreadsheet, do the following:
1. In Excel, open the workbook containing that data that you want to insert.
2. Select and copy the data that you want.
Keyboard shortcut You can press CTRL + C to copy the data.
1. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.
2. On the Home tab, in the Clipboard group, click the arrow below Paste, and select Paste Special.
3. In the Paste Special dialog box, under As, select a Microsoft Excel Worksheet Object.
4. Select the Paste link check box and click OK.
To edit a selection of cells from a linked Excel spreadsheet, do one of the following:
* To edit the data from within Excel, right-click the object on the slide, point to Linked Worksheet Object, and select Edit.
* To update the data on the slide to match the data in the original Excel file, right-click the object on the slide, and click Update Link.
