How to make multiple charts in excel using vba

[@karinaadcock]

Hope you learnt something new and interesting. Thanks for watching and please Like, Comment and Subscribe.

[@Stopcombovers]

I am so glad I found your video!!! Thank you for making it and posting! It’s so refreshing to see a video working with data that resembles mine, you saved me months of trial and error!

[@PiroMat15]

Right now, I have around 1000 charts to do, and I must say that I love You :) That's piece of code what I was looking for, exactly. Thank You so much.

[@yem.t.3930]

Thank you sooo much Madam! Very clear, easily understandable, clear video and audio ! would be happy for more tutorials ! Cheers !

[@SGH-rt6ci]

Dear Ms Karina, clear brilliant explanation ! btw your pleasant voice makes this tutorial easy to graps

[@esdrasjesustorresramirez5417]

Thanks for your amazing work. This was a terrific example of Macros.

[@JHatLpool]

Great demonstration. Nice, clear description. Thanks !

[@isaaccastillo8628]

Thank you so much Karina, Lord Jesus bless you!

[@discozhang9353]

I tried exactly same codes, but my charts got all the series instead of only one serie for each graph, is this happen to you before? Thanks a lot

[@yaseminatalay1563]

Yes, happened to me. make sure your cursor is on a blank cell.

[@nhlanhlamakondo5474]

@@yaseminatalay1563 thank you , i was struglling with same problen

[@sandycarr-q7b]

HELLO, how can I plot the columns and align the plots next to each other instead of stack on top of each other?

[@hopewu7173]

May I please know how to add trendline with equation in VBA as well? thanks a lot

[@ShyanakaDananjaya]

Solution for all the data in one plot: You can set the source data for the interested column by adding .SetSourceData Source:=ActiveSheet.Range("B2:B18") before .ChartType line which would get rid of all the data being plotted in the same chart.

[@davidedri4676]

not working, it gets all columns in only one plot How can in the same code insert a selection of several columns with the same time base in one graph.

[@viralkumarpatelkpcl339]

I wanted to create one chart with multiple Y variable. So how to create it??

[@frevanneste7595]

Hi, can I Add 2 types of Y values into 1 chart?

[@bhavanth1]

Hy Thanks for the video. Can you also make another one where I can have single chart with 3 values in same chart using VBA. With different colors

[@yaseminatalay1563]

How can we add the charts on a separate worksheet and prevent them stacking on top of each other?

[@karinaadcock]

You probably want something like this: kzbin.info/www/bejne/d6DYf4tobJqor68

[@yaseminatalay1563]

@@karinaadcock Thank you - this is very helpful. I have one more question; what if there are more series for each chart. For example, what if the series repeat starting from row 21 with same date and same column titles but different values in each cell. I have a model output that repeats for 100 series and would like to plot them all. Thanks.

[@leoricardo5743]

This is the best. Now lets test in and see if it works (here as i have to make 100 similar graphs, each with the same date but 4 series. I was also trying named ranges. Can you add these in?

[@prathapg5866]

Thank you for your video Karina, I have a couple of questions like is it the same for pie charts too (xlpie) and how to navigate to the respective field after selecting a slice of a pie chart it would be really helpful for me. Thank you

[@zij5224]

Thanks, very helpful! What if I have different X axis? Could you suggest?

[@sgdingman]

Thanks, this is very helpful.

[@genson332]

Hi thank you very much for this information and detailed explanation. Can you help me to send all created graph to another sheet? I'm so sorry for asking too much. I hope you can help me. Thank you very much

[@franciscomelendez3398]

not working, it gets all columns in only one plot

[@nasroml12]

thx a lot, this is so useful