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!
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?
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
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.
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
@@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.
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.
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!
Thank you sooo much Madam! Very clear, easily understandable, clear video and audio !
would be happy for more tutorials !
Cheers !
Dear Ms Karina, clear brilliant explanation ! btw your pleasant voice makes this tutorial easy to graps
Thanks for your amazing work. This was a terrific example of Macros.
Great demonstration. Nice, clear description. Thanks !
Thank you so much Karina, Lord Jesus bless you!
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
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?
Thanks, very helpful! What if I have different X axis? Could you suggest?
May I please know how to add trendline with equation in VBA as well? thanks a lot
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
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
Yes, happened to me. make sure your cursor is on a blank cell.
@@yaseminatalay1563 thank you , i was struglling with same problen
HELLO, how can I plot the columns and align the plots next to each other instead of stack on top of each other?
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.
Thanks, this is very helpful.
Hope you learnt something new and interesting. Thanks for watching and please Like, Comment and Subscribe.
I wanted to create one chart with multiple Y variable. So how to create it??
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
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.
Hi, can I Add 2 types of Y values into 1 chart?
thx a lot, this is so useful
How can we add the charts on a separate worksheet and prevent them stacking on top of each other?
You probably want something like this: th-cam.com/video/AouNX275uyM/w-d-xo.html
@@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.
not working, it gets all columns in only one plot