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!
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.
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.
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.
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
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
The most explicit tutorial on chart i have ever come across. Basically, all the tutorials you have made so far are exemplary. Keep going.
Your videos are the best I've ever seen, I mean it.
Thanks so much Alex, I appreciate the comments!
These guys trained me in advanced VBA in Manchester, very good indeed. Still using VBA 6 years later
Excellent video! I love the little tips and tricks along the way...so valuable to us noobs!
Thanks! Glad you found it useful and thanks for watching!
I learned a lot from this video. thanks a lot!
You're very welcome! Happy to hear that you found it useful!
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!
As always, an incredibly useful tutorial. Exactly what I needed to know. Thanks!
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.
Amazing tutorial! This saved my butt at work :D Thank you!
Happy to hear it helped, thanks for taking the time to leave a comment!
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.
All these tutorials have helped me a ton. Thanks!
As always, excellent tutorial. THANKS!
I appreciate the comment, thanks so much!
You sir are a god amongst men!
amazing!! i love watching these tutorials.
It is not common to see a RUclips video with CERO negative votes. It talks about quality.
Thanks! I'm sure it won't last forever!
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.
Cheers Dimitri, thanks for the feedback!
Thank you!!!
You're welcome Julia, thanks for watching!
GREAT video!
Thanks for the vids, it’s extremely awesome!
How do you create an XY scatter chart using data from an two dimensional array?
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
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?
Could you please provide the Source File for our practice.
Charts.add is not working for me. I am working on MsOffice 2013 version. Please help
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
/r/excel would be a perfect place to help you with your code.
Andrew, do you have video with candle stick chart?
Hi there, sorry no we don't have any videos on candle stick charts (I just had to Google what they are!)
@@WiseOwlTutorials 😂😂😂... Thank you!!
███████ Сool tutorials ... Thanks ███████
Fully agreed, 50 shades of grey is a terrible movie.
I'm sorry that you had to watch it.