Excel Chart and Data to PPT

[hardeep.kanwar]

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

 

[Simon Lloyd]

Hardeep, take a look here 'Automates copy/paste from Excel to PPT -
Presentation Helper' (http://tinyurl.com/djod6e) it will help you a long
way towards your goal!

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

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Jon Peltier]

Or you could read up on the techniques here:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[hardeep.kanwar]

Or you could read up on the techniques here:

'Using Excel with Other Office Applications'
(http://peltiertech.com/Excel/XL_PPT.html)

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
'Advanced Excel Conference - June 17-18, 2009 - Atlantic City | Peltier
Technical Services' (http://tinyurl.com/crqwu6)
_______



Presentation Helper' (http://tinyurl.com/djod6e)) it will help you a
long
Forums' (http://www.thecodecage.com/forumz/showthread.php?t=85137)

Thanks for Reply

But i don't know where to Start. And i am totally Stupid in VBA and
MACROS

So Please find the Attached File i.e. EXCEL and PPT Files

IN Excel Files i have Chart and Their Data

I want to paste these Chart and Data in PPT.(See the PPT FILE)


Thanks in Advance

Hardeep kanwar


+-------------------------------------------------------------------+
|Filename: Excel Charts.zip |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=108|
+-------------------------------------------------------------------+

 

[Jon Peltier]

You'll have to work it out for your particular setup. If you need a primer
on VBA, check out these articles:

http://peltiertech.com/WordPress/how-to-use-someone-elses-macro/
http://peltiertech.com/WordPress/how-to-recording-your-own-macro/
http://peltiertech.com/WordPress/how-to-fix-a-recorded-macro/

And post your replies at the top of the message, like everyone else does, so
they're easier to follow.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______