How to graph Multiple lines in 1 Excel plot | Excel in 3 Minutes

The purpose of this video is to show how to add up only certain cells in excel by using the Sumif function. The example being used today is part of my personal budgeting spreadsheet that I use in excel. If you are interested hit the link below...
I hope you found this video helpful. Please consider subscribing to the channel for many more videos to come!
#ExcelPlots
#Excel
#Microsoftoffice
#multipleplots
#3minuteexcel
#easyexcel

[@hambaallah5586]

Wow wow woowww ❤❤❤❤❤ thanks for making my life easier... Best tutorial ever

[@whatsup7184]

Highly Recommended for Anyone Whose Excel 2020 Version Roaming numerous chart-making videos on YT. This is the most simple to operate with clear explanation and straightforward on how to make a simple chart. Simple, Easy, and Save a lot of time. I just made it and all I need to spend time to familiarize this functioning tool in Excel. Thumbs UP and Again The Most Highly Recommended video for ALL.

[@franciscoalonso1721]

Thank you, you actually helped me so much.

[@lucyricardo8529]

You rock! This was truly the simplest and shortest lesson available and it really helped me out of a jam for my big presentation this week!!!!!

[@focusfactory3345]

Awesome! I am glad I could help

[@monniecyl533]

@@focusfactory3345 what can I do if there are a hundred series, i think shouldn't be done manually?

[@dilshaniamith2077]

Super Clear, Super Simple. Thankyou

[@sudipkumarnandi9094]

What a teaching capacity sir 🙏🙏🙏

[@kutlwanotm]

THANK YOU! Simple and straight to the point!

[@karonemcdaniel7476]

OMG. Thank you so much! This was so simple. Best video ever!!!!!

[@catherinenankanja691]

Thank you so much, you have made my work simpler

[@srikanthdiyyala]

Simply superb simplified

[@ishabhatt1481]

Thank you for this turotial! Just one question, what if your years are little different for each player, in case, one player has additional year

[@ajaiajai27]

Great Help!!! Many thanks!!

[@richardbryanesq]

Dude this is freakin' awesome! Thank you so much.

[@scorzai921]

Thanks lot mate! its really helpful.

[@warriorspartan1697]

Thank you very much for the lucid explanation.

[@simpleexcelexamples9619]

Thank you for this video! Your voice is very pleasant to hear 🙂

[@misterwill3625]

Wow! The quickest chart video that I've seen. Thank you. I'm saving this for future reference.

[@focusfactory3345]

Glad you found this helpful!

[@ice.ringer1248]

BRUHHHH YOURE A LIFESAVER!!! THANKS SO MUCH!!! 👏👏👏👏👏👏👏👏

[@angelicapayan6323]

THANK YOU SO MUCH THIS WAS SO HELPFUL

[@Soldier-yu2ml]

This was helpful for my class, thanks!

[@NoumanKhan-ts4hs]

SERIOUSLY BROOOOO SIMPLE AND EFECTIVE🤩🤩🤩🤩🤩🤩

[@quickexcel2412]

Nice 👍

[@prashantganatra7209]

Nicely explained 👌 thank you

[@sefaguluzadeh6105]

I had problems on the bottom part.I add the dates but it wrote there some of them not all the dates,what could be the reason? or how can I solve the problem?

[@YeseniaJimenezAdonaiNissi]

Thank you!!!! Super helpful

[@PhilipBlank]

Thanks for the video!

[@rufnek3124]

your a life saver👍

[@Omaralkhudhayr]

Thank youu so muchh you literally saved me

[@Zchaee]

Thank you so much!

[@jondownes4103]

Thank you for your help, liked and subbed 🤙

[@alexgehales]

Thanks I just learned something

[@motlatsotlatso4612]

Thank You. Very helpful🙏😊

[@jamespaul4618]

Thanks. This video was very helpful.

[@latibra6407]

Thank u brother God bless u

[@namilachathuranga6129]

Thank you !

[@santiagomalagon6345]

super fast, super clear, super simple

[@katiangii4448]

Thank you for explaining!! Very easy to follow

[@focusfactory3345]

Glad you found this helpful!

[@johnsknows3135]

thx a lot quick and too the point!

[@careeredgeschool]

Really helpful, Thanls

[@santoshsharma-pr9bm]

Thank you so much 😊

[@zavankan4796]

Thank you so much

[@baxxx20]

thank you very much

[@devkashyap9049]

Thanks much! This is super helpful.

[@focusfactory3345]

You’re welcome!

[@angelabutera6845]

Thank you.

[@EverydayExplorations1]

Great!!!

[@sadaf5029]

kzbin.info/www/bejne/aoWZi6B7Z6ufoqs

[@rachidt7636]

Thanks a lot , please to share that excel sheet

[@maryaslane1937]

Thank you so much. It is a life saver

[@focusfactory3345]

You’re welcome!

[@monicagutierrez9716]

YOU SAVED ME

[@shashikanttiwari072]

Do u have any course on excel or advance excel ?

[@tabeshforoughi1380]

Very Nicely Explained, Thank You.

[@focusfactory3345]

Thank you!

[@geosolid639]

thank you.

[@ronaldome9988]

THANK YOU

[@yashshah9898]

THANKS MATE

[@simplesolutions5909]

show your setup... its very smooth and calm ...

[@Danielle0722]

Great video!

[@focusfactory3345]

Thank you!

[@lukedwyer1377]

how do I get the graph to go on the page it won't work for me

[@planet_A2Z]

I got benefitted ❤

[@focusfactory3345]

Glad to hear it helped!

[@amyrichardson1781]

What excel is this I need to know trying to add more data to my graph, I'm using mac and not working says my data range is too complex

[@amyrichardson1781]

Please help

[@Ahsan36434]

Thanks

[@thehuskypack2936]

Thank you this helped so much I was very confused

[@focusfactory3345]

Glad it helped!

[@shashikanttiwari072]

If we have to add more series like 15 or 20 series, then is there any shortcut or we have to do it manually

[@lav1093]

do you have the answer?

[@feynstein1004]

I kind of stumbled upon a solution. I'll describe my process here: 1. Make sure your table is formatted correctly. In my case, the first column is always the x-axis and remains the same whereas all the subsequent columns are always plotted on the y-axis as separate series i.e. they don't remain the same. 2. Select the first 2 columns i.e. the x-axis and the first series on the y-axis. Then go to Insert and select a scatter chart of your choice. (Idk if this works for other chart types. I needed scatter and it seemed to work fine for that). Excel will automatically plot the data and give you a chart. 3. Now, when you select the chart, Excel shows you where the data is on the table using colored borders. The first column is usually depicted in purple borders whereas the second column is usually depicted in blue borders. 4. All you have to do is select the border of the second column (blue) and extend it all the way to the end of however many columns you may have. Excel will automatically recognize each column as a separate data series and plot it accordingly. Hope this helps!

[@hatdog6642]

this doesn’t work everytime i add on the vertical part , the graph changes

[@christianisaacssenkungu1630]

Thank you man

[@focusfactory3345]

Of course!

[@kubyly]

thanks

[@tachehallah822]

Hlo teacher I need help you

[@ajmal_ibn_jafarali]

How to add titles

[@leisamaribekkers312]

So did you get data in by just typing in?

[@focusfactory3345]

Yes, in this case I did just type the data in. However, you can import data if you have a lot to import.

[@carlrobertson7200]

Thank you for this, I was literally a drug addicted homeless person but this video helped me start to get my life back on track. I have been sober for 10 months now and have been working a job for the last 3 months. I can finally afford to move off the street, god bless you sir.

[@aliceweekes242]

...what

[@feynstein1004]

@@aliceweekes242 He's making fun of how people seem to exaggerate the positive effect of instructional videos. You know, "This video helped me do this and do that......." 😂

[@lav1093]

Do you know a way without adding each serie one by one? Thank you

[@feynstein1004]

I kind of stumbled upon a solution. I'll describe my process here: 1. Make sure your table is formatted correctly. In my case, the first column is always the x-axis and remains the same whereas all the subsequent columns are always plotted on the y-axis as separate series i.e. they don't remain the same. 2. Select the first 2 columns i.e. the x-axis and the first series on the y-axis. Then go to Insert and select a scatter chart of your choice. (Idk if this works for other chart types. I needed scatter and it seemed to work fine for that). Excel will automatically plot the data and give you a chart. 3. Now, when you select the chart, Excel shows you where the data is on the table using colored borders. The first column is usually depicted in purple borders whereas the second column is usually depicted in blue borders. 4. All you have to do is select the border of the second column (blue) and extend it all the way to the end of however many columns you may have. Excel will automatically recognize each column as a separate data series and plot it accordingly. Hope this helps!

[@jurizx0328]

Uselese more

[@mrCetus]

Dude this is freakin' awesome! Thank you so much.