View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
hardeep.kanwar[_6_] hardeep.kanwar[_6_] is offline
external usenet poster
 
Posts: 1
Default Excel Chart and Data to PPT


HI! Experts

Is it possible with macro to Copy Chart and Range from the Sheets to
PPT

Means, i have one Workbook With 150 Charts and there data in Different

Sheets that means 150 sheet in a workbook.

Note- Sheet 1 data Range is A1:B10. I make the Pie Chart in the Same
Sheet.

My Chart in the Same Sheet in All Sheets i.e 150 Sheets

Now, i want to copy these chart and range and Paste into PPT.

Chart will Paste to ( Click to Add Title ) portion.

And Range Will Paste to (Click to Add Text)

Is it Possible with Macro or VBA or i have to go Manually

Thanks In Advance

Hardeep kanwar


--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85137