Huge Thank you! This was extremely helpful. The reviewers on my paper asked for the individualized data in the graphs. I would not have figured it on my own. You got a new subscriber here!
Wow, this is so helpful- thanks a ton! I want to submit to a journal that requires individual data points, means and SD's. Very clearly explained, but it's too bad that the process is so convoluted in Excel.
Thank for nice explanation. If I have a number of values (i.e. 20) how can i see each value on the bar graph. I mean how can I make bar graph and scattered plot together?
Thx for the helpful video. My data points (y values) are quite close together and the dots overlap in the scatterplot. Should I change the x values so that the data points spread out horizontally or should I keep them all in the same vertical line?
I would say that this is a stylistic decision that should be left up to the author(s). You might consider changing the y-axis because a restricted y range could make it appear that the individual points are close together when they aren't as similar. Assuming that you have a representative y range, a tight cluster is a good feature of your data in so far as the members of the group (or observations) are very similar. I wouldn't alter the x-axis because the point is to show how the individuals do (or do not) represent the group/condition average.
Thanks for the tutorial. I've ran into some issues with this, however. I have 20 data points, yet only 3 are displayed in the plot when I follow your method. Any idea on what might bewrong? I've plotted the data points with respect to the secondary y-axis which covers the whole range of the values, I've also added a small jitter, so I know that the data points are not overlaying each other. The displayed datapoints also seem to be picked randomly.
Sorry, I don't know. I would have to figure it out. I would look at using box plots in R. They seem to be very easy to provide the kind of graph you are seeking. I hope this helps.
Absolutely amazing video! You saved our bachelors thesis!
Seriously thank you. This was taking forever to figure out and there was truly not another resource on this that was so succinct.
Thank you so much. My boss explained the concept but visualizing with Excel was exceedingly difficult until I watched your video.
Huge Thank you! This was extremely helpful. The reviewers on my paper asked for the individualized data in the graphs. I would not have figured it on my own. You got a new subscriber here!
You are an absolute legend.
THANK YOU.
God bless you!!!! 😭❤️
Dude you rock this was so easy and I was making my life so complicated. Thank you!!
Wow, this is so helpful- thanks a ton! I want to submit to a journal that requires individual data points, means and SD's. Very clearly explained, but it's too bad that the process is so convoluted in Excel.
Great video! Help me get over the barrier I had with my data! Thank you.
Thanks so much! This was a real lifesaver
Thanks, this was extremely helpful!
Very useful Andrew. Thanks a lot.
Greetings from Denmark. Niels and i are in great dept to you oh wise sensei Andrew.
Thank you so much for your video. :) i would have never figured it out on my own T_T
Huge help! Many thanks! :)
this is a great tutorial! thank you!
Very helpful and creative.
Thank for nice explanation. If I have a number of values (i.e. 20) how can i see each value on the bar graph. I mean how can I make bar graph and scattered plot together?
Same as in the example. You will have more rows of data and more data points.
@@andrewleynes9726 If you have 20 values just go ahead and use box-plot... Why bother yourself with all this mess..
I am using the secondary axis for the dots. It doesn't allow me to use scatter type for the dots. I am stuck. Please help.
Look up how to make templates, once you have a template customized for you, you can get to making soft quickly
Thx for the helpful video. My data points (y values) are quite close together and the dots overlap in the scatterplot. Should I change the x values so that the data points spread out horizontally or should I keep them all in the same vertical line?
I would say that this is a stylistic decision that should be left up to the author(s). You might consider changing the y-axis because a restricted y range could make it appear that the individual points are close together when they aren't as similar. Assuming that you have a representative y range, a tight cluster is a good feature of your data in so far as the members of the group (or observations) are very similar. I wouldn't alter the x-axis because the point is to show how the individuals do (or do not) represent the group/condition average.
thanks this really helped!!!
Thank you so much!
Thank for clearly explanation
Thanks , thats good stuff
Thanks for the tutorial. I've ran into some issues with this, however. I have 20 data points, yet only 3 are displayed in the plot when I follow your method. Any idea on what might bewrong? I've plotted the data points with respect to the secondary y-axis which covers the whole range of the values, I've also added a small jitter, so I know that the data points are not overlaying each other. The displayed datapoints also seem to be picked randomly.
nevermind, solved. The issue was with the secondary axis tick box, when I unchecked it, the datapoints showed up.
amazing... thank you
how would you connect the data points in a paired data set?
Sorry, I don't know. I would have to figure it out. I would look at using box plots in R. They seem to be very easy to provide the kind of graph you are seeking. I hope this helps.
Toooo helpful! Thank you v much my man🫶🏾
Thank you sir!
Wonderful.
Legend