Комментарии:
ty sir
ОтветитьThanks my guy ✌🏽
ОтветитьThank you so much❤
ОтветитьYou got 100 by 100
Thank you sir🎉❤😊
Thank you so much 😊
ОтветитьWow wow woowww ❤❤❤❤❤ thanks for making my life easier... Best tutorial ever
Ответитьthanks
ОтветитьUselese more
ОтветитьThank you, you actually helped me so much.
ОтветитьThanks
ОтветитьThank you this helped so much I was very confused
Ответитьthx a lot quick and too the point!
Ответить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!
I got benefitted ❤
ОтветитьThank you for explaining!! Very easy to follow
ОтветитьDo you know a way without adding each serie one by one? Thank you
ОтветитьWow! The quickest chart video that I've seen. Thank you. I'm saving this for future reference.
ОтветитьNicely explained 👌 thank you
ОтветитьHow to add titles
Ответитьhow do I get the graph to go on the page it won't work for me
ОтветитьYOU SAVED ME
ОтветитьGreat video!
ОтветитьThis was helpful for my class, thanks!
ОтветитьThanks much! This is super helpful.
ОтветитьThank you.
ОтветитьThank You.
Very helpful🙏😊
Thanks. This video was very helpful.
ОтветитьVery Nicely Explained, Thank You.
ОтветитьThank you so much. It is a life saver
Ответитьshow your setup... its very smooth and calm ...
ОтветитьThank you!!!! Super helpful
ОтветитьThank you man
ОтветитьOMG. Thank you so much! This was so simple. Best video ever!!!!!
ОтветитьBRUHHHH YOURE A LIFESAVER!!! THANKS SO MUCH!!! 👏👏👏👏👏👏👏👏
Ответитьthis doesn’t work everytime i add on the vertical part , the graph changes
ОтветитьTHANK YOU
ОтветитьSERIOUSLY BROOOOO
SIMPLE AND EFECTIVE🤩🤩🤩🤩🤩🤩
Thanks for the video!
ОтветитьThank you very much for the lucid explanation.
ОтветитьReally helpful, Thanls
Ответитьyour a life saver👍
ОтветитьSo did you get data in by just typing in?
ОтветитьIf we have to add more series like 15 or 20 series, then is there any shortcut or we have to do it manually
ОтветитьDo u have any course on excel or advance excel ?
Ответитьthank you.
ОтветитьThank u brother God bless u
Ответить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
ОтветитьDude this is freakin' awesome! Thank you so much.
ОтветитьTHANK YOU SO MUCH THIS WAS SO HELPFUL
Ответить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
Ответить