Excel VBA Introduction Part 50.1 - Introduction to Charts in VBA

[@sim7717]

The most explicit tutorial on chart i have ever come across. Basically, all the tutorials you have made so far are exemplary. Keep going.

[@kellyspoolhall761]

Excellent video! I love the little tips and tricks along the way...so valuable to us noobs!

[@WiseOwlTutorials]

Thanks! Glad you found it useful and thanks for watching!

[@alexsandoval7636]

Your videos are the best I've ever seen, I mean it.

[@WiseOwlTutorials]

Thanks so much Alex, I appreciate the comments!

[@davidgoldstraw9892]

These guys trained me in advanced VBA in Manchester, very good indeed. Still using VBA 6 years later

[@mustakimomar7400]

I learned a lot from this video. thanks a lot!

[@WiseOwlTutorials]

You're very welcome! Happy to hear that you found it useful!

[@petemenhennet9792]

Excellent video - just what I needed to help with my current project which has an embedded chart that has to be automatically updated each time the macro is run. Thanks for such a clear presentation!

[@mikajulin]

Amazing tutorial! This saved my butt at work :D Thank you!

[@WiseOwlTutorials]

Happy to hear it helped, thanks for taking the time to leave a comment!

[@quickrows4064]

As always, excellent tutorial. THANKS!

[@WiseOwlTutorials]

I appreciate the comment, thanks so much!

[@imtiazulhaque6328]

Absolutely phenomenal :) Your tutorials have helped me turn into a Macro lover from a complete VBA ignorant person. Kudos..I have run into a problem however while generating a chart with a secondary 'Y' axis, if you can help me with that it would be greatly appreciated. Again, can't thank you enough for all the amazing comprehensive video tutorials that you have put together which have absolutely made a difference in my life in a massive way.

[@Smokeyl337]

All these tutorials have helped me a ton. Thanks!

[@n.b.4155]

As always, an incredibly useful tutorial. Exactly what I needed to know. Thanks!

[@amandafernandesramospasson5862]

amazing!! i love watching these tutorials.

[@abhijitmaitra2200]

Fantastic tutorial.........you are simply the best when it comes to VBA. I have a request, can you please make a video on pivot tables using vba ? It would be really helpful for a lot of people.

[@DimitriBoyarski]

Awesome as always, imho nice extra topic to cover would have been generating charts from arrays and variables, though not sure if that's too much of a niche issue to bother with in a vid already over an hour long. Thanks man.

[@WiseOwlTutorials]

Cheers Dimitri, thanks for the feedback!

[@deannorris1649]

You sir are a god amongst men!

[@martinmulligan4327]

How do you create an XY scatter chart using data from an two dimensional array?

[@juliadown5868]

Thank you!!!

[@WiseOwlTutorials]

You're welcome Julia, thanks for watching!

[@viveksvkola]

Could you please provide the Source File for our practice.

[@TheSardOz]

Andrew, do you have video with candle stick chart?

[@WiseOwlTutorials]

Hi there, sorry no we don't have any videos on candle stick charts (I just had to Google what they are!)

[@TheSardOz]

@@WiseOwlTutorials 😂😂😂... Thank you!!

[@mikey38632]

Can one address the data points in a series in a loop? So if a value meets a condition, the formatting for that point is different?

[@hussnainahmedyaser8442]

Andrew, Thank you very much for very informative Tutorial. I have a situation where I would like to change the Series names (Chart Legend) to a value located in a cell in the spreadsheet, the location of the cell should be dynamic. For example if I create a Chart with Legends series names: Series 1 Series 2 and Series 3 How would I be able to change these names to values stored in a cell. The location of the cells can change (Dynamic location). I hope I was able to explain the problem, let me know if you need additional information. Thank you in advance for your time. Regards, Hussnain

[@deandevilliers2799]

GREAT video!

[@rinkusharma2002]

Charts.add is not working for me. I am working on MsOffice 2013 version. Please help

[@nguyenthanhmy1702]

Thanks for the vids, it’s extremely awesome!

[@quickrows4064]

It is not common to see a KZbin video with CERO negative votes. It talks about quality.

[@WiseOwlTutorials]

Thanks! I'm sure it won't last forever!

[@vaidehicrs9898]

Hi WiseOwl, I like all your videos on excel vba. They are really very helpful. I have a 36 x 36 matrix of data (numbers). I would like to get the sum of each column and plot the graph of (column Sum=Y axis) vs (Column number=X axis). Is there any way I can do this using for loop ? I can manually do it using the below code. But I am very bad at coding. It would be great if you could help me. Sub simpleGraph() Dim co As ChartObject Dim ct As Chart Dim scl As SeriesCollection Dim ser1 As Series Dim C1, C2, C3, C4, C5, C6, C7, C8, C9 As Range Dim C1Sum, C2Sum, C3Sum, C4Sum, C5Sum, C6Sum, C7Sum, C8Sum, C9Sum As Double 'Dim xaxis() As Variant Set co = Worksheets("BPD Summary Statistics").ChartObjects.Add(Range("F16").Left, Range("F16").Top, 400, 200) Set ct = co.Chart With ct .HasLegend = True .HasTitle = True .ChartTitle.Text = "Seat Cushion:Sum of Columns within Regions" Set scl = .SeriesCollection Set ser1 = scl.NewSeries With ser1 Set C1 = Sheets("Final BPD").Range("A21:A56") Set C2 = Sheets("Final BPD").Range("B21:B56") Set C3 = Sheets("Final BPD").Range("C21:C56") Set C4 = Sheets("Final BPD").Range("D21:D56") Set C5 = Sheets("Final BPD").Range("E21:E56") Set C6 = Sheets("Final BPD").Range("F21:F56") Set C7 = Sheets("Final BPD").Range("G21:G56") Set C8 = Sheets("Final BPD").Range("H21:H56") Set C9 = Sheets("Final BPD").Range("I21:I56") C1Sum = Application.WorksheetFunction.Sum(C1) C2Sum = Application.WorksheetFunction.Sum(C2) C3Sum = Application.WorksheetFunction.Sum(C3) C4Sum = Application.WorksheetFunction.Sum(C4) C5Sum = Application.WorksheetFunction.Sum(C5) C6Sum = Application.WorksheetFunction.Sum(C6) C7Sum = Application.WorksheetFunction.Sum(C7) C8Sum = Application.WorksheetFunction.Sum(C8) C9Sum = Application.WorksheetFunction.Sum(C9) .XValues = Array(1, 2, 3, 4, 5, 6, 7, 8, 9) .Values = Array(C1Sum, C2Sum, C3Sum, C4Sum, C5Sum, C6Sum, C7Sum, C8Sum, C9Sum) .ChartType = xlXYScatterLines End With End With End Sub Thanks & Regards, Vaidehi

[@Tycket]

/r/excel would be a perfect place to help you with your code.

[@ВячеславАнтонов-п3в]

███████ Сool tutorials ... Thanks ███████

[@mrpopsful]

Fully agreed, 50 shades of grey is a terrible movie.

[@WiseOwlTutorials]

I'm sorry that you had to watch it.