Chart and Tables

[balumail75]

Hello all,

I have around 256 slides containing charts and tables. It's in PowerPoint 2007.
For both charts and tables, I have data in separate excel worksheets in a single workbook.

Is it possible to write VBA code, so that the data from excel will update to PowerPoint charts and tables?

This excel data will come for every quarter and the location of the cell data will not change in the worksheets. There are around 15 sheets.

Some data will be from multiple alternate cells for the charts and tables.

How to store lot of range references in the VBA code and update the charts and tables in PowerPoint one-by-one?

Please help.

Thanks,

Regards,
Balu.

[dougbert]

This may be of some help: http://answers.microsoft.com/en-us/o...6-1cc1de79d2e2 (http://answers.microsoft.com/en-us/office/forum/office_2010-powerpoint/automatically-update-chart-in-powerpoint/0b83da16-0044-e011-90b6-1cc1de79d2e2)