How to Add MULTIPLE Sets of Data to ONE GRAPH in Excel

  Рет қаралды 550,777

Chester Tugwell

Chester Tugwell

4 жыл бұрын

This video demonstrates how to display two data sets on one scatter graph.
------------------------

Пікірлер: 77
@jaulpake691
@jaulpake691 Жыл бұрын
Excellent video! You took 3 minutes to explain what hours of googling could not. Thank you!
@ChesterTugwell
@ChesterTugwell Жыл бұрын
Glad it was helpful!
@delphineshen916
@delphineshen916 3 жыл бұрын
OMG u saved my lab report! Thank you
@B1gCs0ngusz
@B1gCs0ngusz 3 жыл бұрын
Same here
@srednualotbus3090
@srednualotbus3090 3 жыл бұрын
Same here
@soumyajitdatta1380
@soumyajitdatta1380 3 жыл бұрын
Same here
@justarandomguywithoutabear7234
@justarandomguywithoutabear7234 2 жыл бұрын
Same
@xmarcthespot
@xmarcthespot 2 жыл бұрын
Same here
@iMusikkForeva
@iMusikkForeva 3 жыл бұрын
I was about to give up on the lab after 4 videos of this, thank you so much!
@mariosmitakidis7691
@mariosmitakidis7691 9 ай бұрын
it took me so many hours of searching through videos, forums and eventualy stumble on your video and it was perfect. Just what i nedded -- Thank you
@potat373
@potat373 3 жыл бұрын
was trying to figure this one out for like 30 mins. good thing i saw this vid. lifesaver thanks!
@user-su4yp1jj7e
@user-su4yp1jj7e 10 ай бұрын
This video saved my task. Thank you so much! I actually saw some other video and got confused but after watching this I could create my task in 10 min.
@mohammedfaraz7878
@mohammedfaraz7878 Жыл бұрын
This saved me a lot of struggle in the assignment, thank you!
@wilfredthomas6601
@wilfredthomas6601 2 жыл бұрын
Thank you so much for a very simplified explanation.
@kirthirampersad6198
@kirthirampersad6198 Жыл бұрын
“Show a legend”… You are the legend!😌
@abiar2450
@abiar2450 3 жыл бұрын
thanks! Short, informative and handy video!
@Cameron-wv3yj
@Cameron-wv3yj Жыл бұрын
Great Video. Straight to the point!
@evanskings_8
@evanskings_8 6 ай бұрын
Thanks for coming through I was really stuck here may God bless your work
@Dominic-jg3no
@Dominic-jg3no 3 жыл бұрын
This helped me so much, thank you!
@orangeca9838
@orangeca9838 Жыл бұрын
Thank you! Very useful and clear.
@bolanleomotunde1343
@bolanleomotunde1343 Жыл бұрын
very helpfull. thankyou , very calm and it worked for my chemistry excel graphing. i needed to put 3 plots on a graph and i used the same process.
@dragonheart1465
@dragonheart1465 2 жыл бұрын
This was really helpful to me, thanks a lot
@dejaneejoshua3026
@dejaneejoshua3026 7 ай бұрын
This video is great. Thank you for this. Learned more from your video than I did while in class
@magnetar6235
@magnetar6235 2 жыл бұрын
That was very helpful, thanks
@ew1usnr
@ew1usnr Жыл бұрын
Thanks. This was a big help.
@chukwuemekachikelu8153
@chukwuemekachikelu8153 3 жыл бұрын
Thank you so much!
@Angie-bi4qu
@Angie-bi4qu 3 жыл бұрын
thank you so much, you help me a lot
@yesitsme1366
@yesitsme1366 Жыл бұрын
exactly what I was looking for - wish I had found this sooner. thank you!
@ChesterTugwell
@ChesterTugwell Жыл бұрын
You're very welcome!
@Emily-wx5qj
@Emily-wx5qj 2 жыл бұрын
you rock Chester.
@broderp
@broderp 3 жыл бұрын
Great video. I had one issue - this only works well if the data is of the same type. How do you do this is the data you want is of different types (percentage vs. number over time) The horizontal axis at the bottom is date, I need to see at what point a specific date a count (number) crosses efficiency (percent - %). The data given to me in one chart with multiple columns labeled "count and efficiency. The data running vertically on the left are the dates.
@BilalRazz
@BilalRazz 3 жыл бұрын
Thank you! 👍
@Joel66_
@Joel66_ 2 жыл бұрын
Thank you for the video this clearly explained how to do it🤝
@queenchege5716
@queenchege5716 10 ай бұрын
Very useful video , thank you
@johnsknows3135
@johnsknows3135 11 ай бұрын
very helpful thx!
@cassinihuygens1288
@cassinihuygens1288 3 жыл бұрын
Thank you!!!
@shakirhussain39
@shakirhussain39 Жыл бұрын
Thanks a lot. you save my time
@dmitriypyak7738
@dmitriypyak7738 Жыл бұрын
Thanks, was very usefull.
@michaelp1856
@michaelp1856 2 жыл бұрын
Is there a way to add many series quickly to the one chart withough manually reading-in the cell ranges? Say if there are only 3 columns in the worksheet, 2 being the X & Y numerical variables, & the other being a categorical variable for which we want a separate series?
@duynguyenduc8710
@duynguyenduc8710 3 жыл бұрын
Very helpful
@MuhammadTalhaKhanCLE
@MuhammadTalhaKhanCLE 2 жыл бұрын
Thanks Alot Sir
@abdalladraz6740
@abdalladraz6740 2 жыл бұрын
Thank you ❤️
@justarandomguywithoutabear7234
@justarandomguywithoutabear7234 2 жыл бұрын
Thank you. You are a Life saver
@crazycontraptions1249
@crazycontraptions1249 Жыл бұрын
ayo
@vincentl4691
@vincentl4691 Жыл бұрын
Great video, thanks for the help. I still had a tough time plotting two sets of water elevation over time. One set of data from the US Geographical Survey (data taken every 3 minutes), and one set of monthly data that was hand written (data taken at random times maybe once a day over the course of a month). The thing is, I discovered that you must have the same time and equal number of time stamps in each data set. So you must copy the handwritten times to the USGS data to the closest time which is what I did. Or I could write a script to extrapolate the USGS elevation, and add a record that matches the time of the handwritten time. And MS Access? I couldn't find a way to graph two record sources.
@guitarwithyumira2547
@guitarwithyumira2547 2 жыл бұрын
thnx this helps alot😊😊😊
@junkmail8883
@junkmail8883 3 жыл бұрын
Absolute lifesaver. Cheers, Chester!
@rixicz8170
@rixicz8170 Жыл бұрын
Thanks!
@zemichaelhailu3893
@zemichaelhailu3893 3 жыл бұрын
awesome!
@zavierik4165
@zavierik4165 16 күн бұрын
Thank you ☝️😢👍🫡 making tge world a better place
@fabiojr64
@fabiojr64 Жыл бұрын
Great work!
@ChesterTugwell
@ChesterTugwell Жыл бұрын
Thank you! Cheers!
@precious1702
@precious1702 Жыл бұрын
THANK YOUUU
@labanibiswas8274
@labanibiswas8274 Жыл бұрын
Thank you
@marilynjubileerose
@marilynjubileerose 2 жыл бұрын
What if I have multiple data sets in separate sheets? Could I still follow this process? Thank you!
@yunongli2872
@yunongli2872 7 ай бұрын
Thank you so much! excel was driving me crazy
@faiksami94
@faiksami94 Жыл бұрын
Hello sir. How did you seperate the years? Is it by mouse after the filter or something else ?
@WilfredSemazzi
@WilfredSemazzi Жыл бұрын
Thanks
@ezzafaiharah365
@ezzafaiharah365 23 күн бұрын
thank you soooo much
@mulshiwaters5312
@mulshiwaters5312 Жыл бұрын
Excellent
@ChesterTugwell
@ChesterTugwell Жыл бұрын
Thank you! Cheers!
@1445blake
@1445blake Жыл бұрын
how come whenever I try to do the same thing except when I dont do CTRL+shift+down and i just click and drag down I can then no longer select y-values?
@mumtrz
@mumtrz 2 жыл бұрын
why do my ctrl+shift+down is sometimes not working? like, it work sometimes but other times it just refuses
@michallebel3236
@michallebel3236 Жыл бұрын
How do I do this in google sheets
@Facelearn
@Facelearn 2 ай бұрын
I want to show the user login date, time and user names on one graph. Could it be possible to show three in one graph
@lukeelliott4093
@lukeelliott4093 Жыл бұрын
How can I do this on a Chromebook?
@AbdulsalamAlHadi
@AbdulsalamAlHadi 3 жыл бұрын
💛🧡🔥
@dineshjoshi8238
@dineshjoshi8238 6 ай бұрын
How to locate inresection point of line
@DanBurgaud
@DanBurgaud Жыл бұрын
Here is my problem: I have two sets of data (one sorted ascending, the other descending). When I select the 1st series, it added to the Graph as usual. When I select the 2nd series (descending data), it only added the 1st data point...
@nasrinmeghla7270
@nasrinmeghla7270 24 күн бұрын
but there is no series X value and series Y value only series name and series value what should i do now? please tell me.
@samguest78
@samguest78 2 жыл бұрын
What about, say… 12 data series? All of the same X and Y axis type
@FireEagle89
@FireEagle89 Жыл бұрын
My third chart messes up the entire graph 😔
@maxinechantel2393
@maxinechantel2393 4 ай бұрын
Very helpful. Thanks
Weekly Sales chart in Excel
10:34
PK: An Excel Expert
Рет қаралды 397 М.
Build 5 ADVANCED Excel Charts from Scratch
14:14
Kenji Explains
Рет қаралды 210 М.
Can A Seed Grow In Your Nose? 🤔
00:33
Zack D. Films
Рет қаралды 29 МЛН
Идеально повторил? Хотите вторую часть?
00:13
⚡️КАН АНДРЕЙ⚡️
Рет қаралды 9 МЛН
لقد سرقت حلوى القطن بشكل خفي لأصنع مصاصة🤫😎
00:33
Cool Tool SHORTS Arabic
Рет қаралды 28 МЛН
Finger Heart - Fancy Refill (Inside Out Animation)
00:30
FASH
Рет қаралды 29 МЛН
Excel -  how to plot 2 vertical y-axes on a line graph
5:37
Laura Smith
Рет қаралды 142 М.
AWESOME Excel trick to combine data from multiple sheets
7:27
Chandoo
Рет қаралды 1,1 МЛН
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
How To... Plot Multiple Data Sets on the Same Chart in Excel 2010
7:21
Eugene O'Loughlin
Рет қаралды 2 МЛН
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 285 М.
Excel: Two Scatterplots and Two Trendlines
7:36
BurkeyAcademy
Рет қаралды 255 М.
Plot Multiple Lines in Excel
1:57
Gmaz
Рет қаралды 1,3 МЛН
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 234 М.
UNO!
0:18
БРУНО
Рет қаралды 3 МЛН
Ăn trái gì thế/kỳ kỳ tv & Family #shorts
0:13
Kỳ kỳ tv & Family
Рет қаралды 16 МЛН
Застрял подо льдом😨 #freekino
0:35
FreeKino
Рет қаралды 785 М.