Export Excel Charts/Graphs into PowerPoint using VBA

R

Rach

Hi,

Does anyone know how to export charts/graphs from EXCEl
into Powerpoint-Microsoft Charts though VBA code. I would
like to import the underlying data with the chart as well.
I know we can paste as an Excel object in power point
which links the Excel file to the power point, but this
increases the file size.
Microsoft Power point has a feature called Microsoft
charts that allows to create charts and graphs in
Powerpoint. what I want to do through VBA is access the
powerpoint chart and select the chart options (e.e - bar,
pie graph) and then populate the powerpoint chart table
with the Excel data.

Can this be done in VBA.

Thanks a lot!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top