LucasLondon
11-26-2008, 05:36 AM
Hi,
Is it possible using VBA to extract the underlying data from a chart created in powerpoint, i.e from the underlying datasheet?
I have a series of charts in powerpoint in multiple slides. When u click on the chart, the underlying datasheet holding the source data can be viewed.
I would like to copy the range "A1:H20" from all charts (the underlying sheet) in powerpoint on the slide 10 to 23 and paste it into a new normal excel workbook.
Would this be easy to do?
Thanks
Lucas
Is it possible using VBA to extract the underlying data from a chart created in powerpoint, i.e from the underlying datasheet?
I have a series of charts in powerpoint in multiple slides. When u click on the chart, the underlying datasheet holding the source data can be viewed.
I would like to copy the range "A1:H20" from all charts (the underlying sheet) in powerpoint on the slide 10 to 23 and paste it into a new normal excel workbook.
Would this be easy to do?
Thanks
Lucas