Just come across your channel after searching for info about Exporting Charts to PowerPoint. Oh man, I couldn't thank you more. These tutorials are what I was l looking for about a week now. Just subscribed and liked. I could have pressed the thumbs up if there was one. Cheers!!!
Outstanding presentation of automation! Your teaching skills are super clear, succinct and easy to follow. Reminds me of a great teacher-- Richard Feynman. Way to go! Liked & subscribed
Thank you so much for this video!!! It's easy to understand your explanation in each change you made on the script. I'm gonna use the script to automate my monthly reports. Again, thanks! :D
hi great presentation but as soon as I tried it, I get the same error as Yuda Pratama "Dim PPTApp As PowerPoint.Application" User defined-type not defined" when I looked up what this error means - it says I have to define the data types in Type / End Type statement - but doesn't show an example of how to do this
Thank you very much, I have a question: In my workbook I have multiple charts each in a separate sheet, so multiple sheets and in each of them is one chart, I am guessing I will need to loop through sheets, and copy past charts from them to PPT. Can you help with the code syntax?
So can you specify which powerpoint template that the charts will be placed into? Also, I have many charts on the same WS and many WS in the WB. For some reason the multiple charts in the workbook fails on my workbook, unless its a WB that is very uncomplicated. most of these charts are pivot charts as well.
I would like to be able to copy charts and tables from Excel into an existing PPT Slide Master. Your instructions work great for a new presentation, but I need them to go into an existing PowerPoint presentation. Any ideas?
You can make links to the charts, but not to other excel objects. That's why I was looking for a way of mirroring charts and objects to the slides (same as the video but with multiple charts and objects that would keep the same position than in the original excel tab). You can do this very easily exporting pdfs but it's impossible to get rid of a white frame around the resulting document..
Hi, thank you so much. Amazing video. Do you have a video for also automating titles to go into each slide that is created? or maybe using a specific PowerPoint template that already has headers?
Hello, Firstly, thank you for sharing this. I tried to run your query but I have a problem, it said : Shapes(unknown member) : invalid request. Clipboard is empty or contains data which may not be pasted here. I tried to figure out the solution but have not found yet. Could you help me to explain why it occured? Thank you
When I tried to run the second routine, it stopped after one chart. Is there a difference when the chart itself is a sheet (such as after moving a chart to its own sheet), rather than the chart being on a sheet?
This video is AMAZING. One question tough; is there anyway you could insert a Chart into an existing slide with headers and text in a PPT that already has been created?
Hello sir, thank you very much for the tutorial. I am getting 1004 errors, object-defined or application-defined errors at the Chrt.Copy line, but only for some sheets and I can't figure out the reason
can anyone help me please, how to copy from a Chart-Sheet te picture/chart to powerpoint ? When I used the code form the video it take the chats just from "normal" worksheets not from chartsheets
VBA is for super users they said.... I’d like to automate a frequent reporting pack that contains around 120 slides with approx 100 charts and tables from a number of excel sources. It’s a nightmare. I started this new role 2 months ago and it’s essential that I find a solution to automate this process so I don’t waste my life copying and pasting charts. I’m even exploring UI path’s RPA solution but would prefer VBA so it can be adopted by my successors. The main challenge is that I receive different files each month by email. On the plus side, the document (excel) format and layout is consistent.I store them in monthly folders (until I get SharePoint libraries set up) The files are consistent (same template used each month), so the chart and ranges are the same. Any advice would be awesome!
Well the fact that all the files are laid out consistently is probably the biggest hurdle to overcome. If I were in your situation I would try to do the following: 1. Have all the files in one place (it sounds like this has already been accomplished). 2. Have a VBA script that loops through each file in that folder, opens it up and gets ready to copy it. 3. Open up the PowerPoint presentation (I'm assuming you're using a template). 4. The tricky part is copying and pasting the charts. Right now, what's the logic for putting which charts where? 5. Maybe have a "master" list, where you have each workbook, the worksheet the object lives on, the object id itself, and which slide that object is intended to go. 6. Use that table as your basis for determining where things go. I did something like this many years ago, and I still have the code if you'd like to see it. Not sure if it'll work in your exact case but hopefully give you a base to work off. If you want it just email me at coding.sigma@gmail.com Also, if you have the code that you're planning to use I'd be happy to take a look at it.
Hello, I get a runtime error 445 - 'object doesn't support this action'. I'm using a Pareto Chart (Histogram). The code works for a standard 2-D Column chart.
Hey John, Unfortunately, the VBA model was not extended for new chart objects so some functionality may not work with all of the them. For example, I believe charts like Tree Maps can only be pasted as pictures.
Sigma Coding thanks for the quick reply! Perhaps a workaround will be developed at a later time. Also, keep up the good work! This was a very useful tutorial.
@@SigmaCoding i have one doubt, i have existing ppt containing graph in slides, so when i execute the macro it should delete the existing graphs in slide and should update latest one, why am asking this is because i need to update the graphs based on latest data. Thanks in advance...
Just come across your channel after searching for info about Exporting Charts to PowerPoint. Oh man, I couldn't thank you more. These tutorials are what I was l looking for about a week now. Just subscribed and liked. I could have pressed the thumbs up if there was one. Cheers!!!
This is beautiful! Thank you for contributing to this world's productivity
Outstanding presentation of automation! Your teaching skills are super clear, succinct and easy to follow. Reminds me of a great teacher-- Richard Feynman.
Way to go!
Liked & subscribed
Well thank you for that, I've always had a passion for teaching so it's good to see when people find it valuable!
Nice one, could you please help me how to add 3 excel charts is a single PPT slide
This is really helpful. Could you please explain how to define 1st chart as "Chart1" to use ChartObjects("Chart1") call?
Thank you so much for this video!!!
It's easy to understand your explanation in each change you made on the script. I'm gonna use the script to automate my monthly reports. Again, thanks! :D
hi great presentation but as soon as I tried it, I get the same error as Yuda Pratama "Dim PPTApp As PowerPoint.Application" User defined-type not defined"
when I looked up what this error means - it says I have to define the data types in Type / End Type statement - but doesn't show an example of how to do this
Thanks you, excelent presentation, have a happy new year!👍
Ótimo vídeo, me ajudo muito, só gostaria de saber, o que tenho que mudar no código para que ele cole vários gráficos no mesmo slide?
Thank you very much, I have a question: In my workbook I have multiple charts each in a separate sheet, so multiple sheets and in each of them is one chart, I am guessing I will need to loop through sheets, and copy past charts from them to PPT. Can you help with the code syntax?
How can we refer to an exact chart from Excel to copy in PPT. Is there any unique identifier that can be used for this copy paste operation??
So can you specify which powerpoint template that the charts will be placed into? Also, I have many charts on the same WS and many WS in the WB. For some reason the multiple charts in the workbook fails on my workbook, unless its a WB that is very uncomplicated. most of these charts are pivot charts as well.
is there a way to paste the chart as embedded chart into the slide?
great video! How can I add a title box to each PowerPoint slide?
I would like to be able to copy charts and tables from Excel into an existing PPT Slide Master. Your instructions work great for a new presentation, but I need them to go into an existing PowerPoint presentation. Any ideas?
You can make links to the charts, but not to other excel objects. That's why I was looking for a way of mirroring charts and objects to the slides (same as the video but with multiple charts and objects that would keep the same position than in the original excel tab). You can do this very easily exporting pdfs but it's impossible to get rid of a white frame around the resulting document..
Super helpful video, thanks!
Hi, thank you so much. Amazing video.
Do you have a video for also automating titles to go into each slide that is created? or maybe using a specific PowerPoint template that already has headers?
I'm going to be releasing a video soon where I'll be showing you how to build a presentation using Excel Objects.
Hello,
Firstly, thank you for sharing this. I tried to run your query but I have a problem, it said : Shapes(unknown member) : invalid request. Clipboard is empty or contains data which may not be pasted here.
I tried to figure out the solution but have not found yet. Could you help me to explain why it occured? Thank you
When I tried to run the second routine, it stopped after one chart. Is there a difference when the chart itself is a sheet (such as after moving a chart to its own sheet), rather than the chart being on a sheet?
This video is AMAZING. One question tough; is there anyway you could insert a Chart into an existing slide with headers and text in a PPT that already has been created?
Great video
Hello. Love the videos. I just wanted to ask, how would you go about exporting both the data table and the charts onto the same powerpoint slides
I actually have a video that covers this topic, it can be found here: th-cam.com/video/HGab8RbMeo0/w-d-xo.html
Hello sir, thank you very much for the tutorial. I am getting 1004 errors, object-defined or application-defined errors at the Chrt.Copy line, but only for some sheets and I can't figure out the reason
can anyone help me please, how to copy from a Chart-Sheet te picture/chart to powerpoint ? When I used the code form the video it take the chats just from "normal" worksheets not from chartsheets
what should be done, if we are planning to paste the the two chartobjects from the active sheet on same slide but on different positions?
I have a video that covers that topic. Here is the link: th-cam.com/video/HGab8RbMeo0/w-d-xo.html
Great video! How do you set the chart to a specific position in PowerPoint and resize it so it fits the slide?
I have a video about manipulating shapes in PowerPoint using VBA. Here is the link: th-cam.com/video/TyZ47qI0NkQ/w-d-xo.html
I have an error during compile,at "Dim PPTApp As PowerPoint.Application"
User defined-type not defined
i have it too (
Sub ExportChartToPowerPoint_PasteMethods()
undefined by the user)
How to add two charts in one slide
Great code man, thanks!
Happy to help
VBA is for super users they said....
I’d like to automate a frequent reporting pack that contains around 120 slides with approx 100 charts and tables from a number of excel sources. It’s a nightmare. I started this new role 2 months ago and it’s essential that I find a solution to automate this process so I don’t waste my life copying and pasting charts. I’m even exploring UI path’s RPA solution but would prefer VBA so it can be adopted by my successors. The main challenge is that I receive different files each month by email. On the plus side, the document (excel) format and layout is consistent.I store them in monthly folders (until I get SharePoint libraries set up) The files are consistent (same template used each month), so the chart and ranges are the same. Any advice would be awesome!
Well the fact that all the files are laid out consistently is probably the biggest hurdle to overcome. If I were in your situation I would try to do the following:
1. Have all the files in one place (it sounds like this has already been accomplished).
2. Have a VBA script that loops through each file in that folder, opens it up and gets ready to copy it.
3. Open up the PowerPoint presentation (I'm assuming you're using a template).
4. The tricky part is copying and pasting the charts. Right now, what's the logic for putting which charts where?
5. Maybe have a "master" list, where you have each workbook, the worksheet the object lives on, the object id itself, and which slide that object is intended to go.
6. Use that table as your basis for determining where things go.
I did something like this many years ago, and I still have the code if you'd like to see it. Not sure if it'll work in your exact case but hopefully give you a base to work off. If you want it just email me at coding.sigma@gmail.com
Also, if you have the code that you're planning to use I'd be happy to take a look at it.
@@SigmaCoding Thanks for the quick reply. Excellent, will drop you an email.
Help With Error
I am getting a "Compile Error: User-defined type not defined - can someone tell me how to fix this error?
Did you import the PowerPoint Reference Library? Usually that causes the issue.
Thank you, that was the issue - I was seeing Microsoft Office and wasn’t paying attention that it wasn’t Power Point.
Hello, I get a runtime error 445 - 'object doesn't support this action'. I'm using a Pareto Chart (Histogram). The code works for a standard 2-D Column chart.
Hey John,
Unfortunately, the VBA model was not extended for new chart objects so some functionality may not work with all of the them. For example, I believe charts like Tree Maps can only be pasted as pictures.
Sigma Coding thanks for the quick reply! Perhaps a workaround will be developed at a later time.
Also, keep up the good work! This was a very useful tutorial.
Hi how to add charts to the different slides of existing ppt..plz help
If you go in the description, there are link to other videos that cover that topic.
@@SigmaCoding could you plz give me the exact link that i needed...plz
@@SigmaCoding i have one doubt, i have existing ppt containing graph in slides, so when i execute the macro it should delete the existing graphs in slide and should update latest one, why am asking this is because i need to update the graphs based on latest data. Thanks in advance...
Hi, I am struggling same action in python, do you have any reference ?
What are you struggling with?
thank you
:)