Excel VBA Introduction Part 50.2 - Embedding Charts in Worksheets

[@jonathanvillafana5726]

You are the man Andrew!

[@sim7717]

Fab!!!!. Hats off to your each and every attempt of spreading knowledge. Thanks.

[@cheriekorer352]

WiseOwlTutorials

[@krn14242]

Thanks Andrew. Great video.

[@nguyenthanhmy1702]

Thanks for the vids, it’s extremely awesome!

[@janezklun]

Very, very useful, great vid as always, thank you

[@vs_gaming3013]

Hey, Andrew! Could you please make a video with an explanation of the proper use of FullSeriesCollection and the best approaches to make embedded charts filtering?

[@alpishjain1317]

excellent video thank you for making it so simple for us.

[@andreasvinz6091]

Very insightful, thanks a ton! I have a question, though. At 45:56 you write the following code ... co.Chart.Location xlLocationAsObject, "Menu" ... moving all chart objects to the “Menu” sheet. What is the code for copying (instead of moving) all the chart objects to the “Menu” sheet? Unable to figure that out.

[@andreasvinz6091]

Hi Andrew, thanks for your quick response! In your video the charts to be moved (i.e. copied) were actually embedded in other worksheets of the same workbook. So I cannot refer to them just as “Chart1” especially if there is more than one chart embedded in one worksheet, can I? Tried something along the lines of… For Each co In ws.ChartObjects co.Copy ActiveChart.Location xlLocationAsObject, "Menu Next co … unfortunately that did not work, since the way I am referring to the embedded charts seems to be wrong. Where am I making a mistake?

[@Nessus07]

Thank you for very good instruction!

[@nadermounir8228]

Amazing video 📹 👏

[@WiseOwlTutorials]

Thank you Nader!

[@victoropere2107]

just awesome

[@johng5295]

Thanks.

[@WiseOwlTutorials]

You're welcome John, thanks for watching!

[@anilkachhawaha6016]

Thank you very much this Tutorial

[@daniellejay1368]

i love you man

[@MagnusAnand]

Great as usual! One question: when do you use Shapes or ChartObject? Can you do the same with both? Do you have any preference? Why?

[@juanpablohorn6642]

Hello Andrew! It's me again. I have a question regarding the Position Multiple Chart Objects. In your example you have your left value be reset to zero every time the number of charts in a row is reached. My question is: How would I manage to make the left reset on a value greater than zero? Let's say I want them to start arranging themselves on column I. How would the Left calculation look in that case? Thanks in advance Andrew!

[@WiseOwlTutorials]

Hi Juan Pablo! A Range object has a Left property so you can just add this to the result of the existing calculation .Left = existing calculation + Range("I1").Left I hope it helps!

[@juanpablohorn6642]

@@WiseOwlTutorials Hi Andrew! It worked! Thanks a lot! You are the best!

[@WiseOwlTutorials]

@@juanpablohorn6642 Happy to hear that Juan Pablo, you're welcome!

[@rbrtsparkman]

I have created the ChartObject according to this video, then I want to send a msgbox. The msgbox comes up first before the chart displays. I don't want this, can someone help me please?