Export Excel Charts/Graphs into PowerPoint using VBA

  • Thread starter Thread starter Rach
  • Start date Start date
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!!
 
Back
Top