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

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

Focus Factory

3 года назад

405,702 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@giwikwik
@giwikwik - 15.09.2024 22:05

ty sir

Ответить
@Bronxguys
@Bronxguys - 06.09.2024 20:51

Thanks my guy ✌🏽

Ответить
@PujaThapa-e8c
@PujaThapa-e8c - 24.08.2024 18:54

Thank you so much❤

Ответить
@bilalnasir234
@bilalnasir234 - 08.08.2024 04:39

You got 100 by 100
Thank you sir🎉❤😊

Ответить
@santoshsharma-pr9bm
@santoshsharma-pr9bm - 09.06.2024 07:09

Thank you so much 😊

Ответить
@hambaallah5586
@hambaallah5586 - 19.05.2024 19:09

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

Ответить
@kubyly
@kubyly - 05.05.2024 15:54

thanks

Ответить
@jurizx0328
@jurizx0328 - 22.04.2024 19:50

Uselese more

Ответить
@franciscoalonso1721
@franciscoalonso1721 - 04.04.2024 05:20

Thank you, you actually helped me so much.

Ответить
@Ahsan36434
@Ahsan36434 - 25.02.2024 08:27

Thanks

Ответить
@thehuskypack2936
@thehuskypack2936 - 25.09.2023 06:51

Thank you this helped so much I was very confused

Ответить
@johnsknows3135
@johnsknows3135 - 05.09.2023 17:33

thx a lot quick and too the point!

Ответить
@feynstein1004
@feynstein1004 - 10.08.2023 20:23

I had to do this for hundreds of columns and was looking for a way to do it automatically. 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!

Ответить
@planet_A2Z
@planet_A2Z - 18.07.2023 08:43

I got benefitted ❤

Ответить
@katiangii4448
@katiangii4448 - 04.06.2023 16:53

Thank you for explaining!! Very easy to follow

Ответить
@lav1093
@lav1093 - 13.05.2023 02:34

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

Ответить
@misterwill3625
@misterwill3625 - 07.05.2023 08:19

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

Ответить
@prashantganatra7209
@prashantganatra7209 - 12.04.2023 10:45

Nicely explained 👌 thank you

Ответить
@ajmal_ibn_jafarali
@ajmal_ibn_jafarali - 04.04.2023 20:52

How to add titles

Ответить
@lukedwyer1377
@lukedwyer1377 - 26.03.2023 01:53

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

Ответить
@monicagutierrez9716
@monicagutierrez9716 - 17.02.2023 07:39

YOU SAVED ME

Ответить
@Danielle0722
@Danielle0722 - 12.02.2023 06:34

Great video!

Ответить
@Soldier-yu2ml
@Soldier-yu2ml - 27.01.2023 03:52

This was helpful for my class, thanks!

Ответить
@devkashyap9049
@devkashyap9049 - 15.12.2022 18:34

Thanks much! This is super helpful.

Ответить
@angelabutera6845
@angelabutera6845 - 14.12.2022 00:33

Thank you.

Ответить
@motlatsotlatso4612
@motlatsotlatso4612 - 29.11.2022 23:54

Thank You.
Very helpful🙏😊

Ответить
@jamespaul4618
@jamespaul4618 - 29.11.2022 07:45

Thanks. This video was very helpful.

Ответить
@tabeshforoughi1380
@tabeshforoughi1380 - 27.11.2022 06:53

Very Nicely Explained, Thank You.

Ответить
@maryaslane1937
@maryaslane1937 - 25.11.2022 11:07

Thank you so much. It is a life saver

Ответить
@simplesolutions5909
@simplesolutions5909 - 10.11.2022 21:39

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

Ответить
@YeseniaJimenezAdonaiNissi
@YeseniaJimenezAdonaiNissi - 05.11.2022 21:22

Thank you!!!! Super helpful

Ответить
@christianisaacssenkungu1630
@christianisaacssenkungu1630 - 04.11.2022 21:47

Thank you man

Ответить
@karonemcdaniel7476
@karonemcdaniel7476 - 02.10.2022 06:56

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

Ответить
@ice.ringer1248
@ice.ringer1248 - 28.09.2022 05:47

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

Ответить
@hatdog6642
@hatdog6642 - 23.09.2022 12:38

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

Ответить
@ronaldome9988
@ronaldome9988 - 18.08.2022 16:04

THANK YOU

Ответить
@NoumanKhan-ts4hs
@NoumanKhan-ts4hs - 04.08.2022 01:00

SERIOUSLY BROOOOO
SIMPLE AND EFECTIVE🤩🤩🤩🤩🤩🤩

Ответить
@PhilipBlank
@PhilipBlank - 31.07.2022 07:38

Thanks for the video!

Ответить
@warriorspartan1697
@warriorspartan1697 - 11.07.2022 17:00

Thank you very much for the lucid explanation.

Ответить
@careeredgeschool
@careeredgeschool - 27.06.2022 08:32

Really helpful, Thanls

Ответить
@rufnek3124
@rufnek3124 - 20.06.2022 11:52

your a life saver👍

Ответить
@leisamaribekkers312
@leisamaribekkers312 - 19.05.2022 08:57

So did you get data in by just typing in?

Ответить
@shashikanttiwari072
@shashikanttiwari072 - 19.04.2022 11:18

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

Ответить
@shashikanttiwari072
@shashikanttiwari072 - 19.04.2022 11:16

Do u have any course on excel or advance excel ?

Ответить
@geosolid639
@geosolid639 - 17.04.2022 14:09

thank you.

Ответить
@latibra6407
@latibra6407 - 28.03.2022 16:45

Thank u brother God bless u

Ответить
@amyrichardson1781
@amyrichardson1781 - 24.03.2022 23:33

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

Ответить
@mrCetus
@mrCetus - 10.03.2022 01:38

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

Ответить
@angelicapayan6323
@angelicapayan6323 - 17.02.2022 06:46

THANK YOU SO MUCH THIS WAS SO HELPFUL

Ответить
@ishabhatt1481
@ishabhatt1481 - 16.02.2022 22:19

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

Ответить