If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|