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

Excel Chart and Data to PPT
 

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!

hardeep.kanwar;304474 Wrote:
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)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85137

Excel Chart and Data to PPT
 

Or you could read up on the techniques he

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...00906ACNJ.html
_______


"Simon Lloyd" wrote in message
...

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!

hardeep.kanwar;304474 Wrote:
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)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85137

Excel Chart and Data to PPT
 

Jon Peltier;304794 Wrote:
Or you could read up on the techniques he

'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)
_______


"Simon Lloyd" wrote in message
...

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

hardeep.kanwar;304474 Wrote:
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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile:
'The Code Cage Forums - View Profile: Simon Lloyd'
(http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel Chart and Data to PPT - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...ad.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|
+-------------------------------------------------------------------+

--
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

Excel Chart and Data to PPT
 

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...e-elses-macro/
http://peltiertech.com/WordPress/how...our-own-macro/
http://peltiertech.com/WordPress/how...ecorded-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...00906ACNJ.html
_______


"hardeep.kanwar" wrote in message
...

Jon Peltier;304794 Wrote:
Or you could read up on the techniques he

'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)
_______


"Simon Lloyd" wrote in message
...

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

hardeep.kanwar;304474 Wrote:
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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile:
'The Code Cage Forums - View Profile: Simon Lloyd'
(http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel Chart and Data to PPT - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...ad.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|
+-------------------------------------------------------------------+

--
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