Creating publication quality bar graph (with individual data points) in excel

This video describes how to create a bar graph and then overlay the individual data points for each group to show the within-group variability.
Creating publication quality graph in excel ( • Creating a publication... ).

[@nreggente]

Seriously thank you. This was taking forever to figure out and there was truly not another resource on this that was so succinct.

[@shiprapuri3214]

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!

[@maximebrants8243]

Absolutely amazing video! You saved our bachelors thesis!

[@aamyavohra1710]

Dude you rock this was so easy and I was making my life so complicated. Thank you!!

[@thi8a]

You are an absolute legend. THANK YOU. God bless you!!!! 😭❤️

[@annaireinova3195]

Thanks, this was extremely helpful!

[@Steve-kq1vl]

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.

[@deulgis6644]

Thanks so much! This was a real lifesaver

[@Raxor191]

Greetings from Denmark. Niels and i are in great dept to you oh wise sensei Andrew.

[@philipjanz9753]

Great video! Help me get over the barrier I had with my data! Thank you.

[@shailaayisha]

Thank you so much!

[@javierdelpino7374]

Thank you so much for your video. :) i would have never figured it out on my own T_T

[@rameshabt8124]

Very useful Andrew. Thanks a lot.

[@yoonheevivienko]

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.

[@mohammadsalahradi2293]

Very helpful and creative.

[@benysmart1643]

Thank for clearly explanation

[@kingabarbara1168]

this is a great tutorial! thank you!

[@kasiamyga8687]

Huge help! Many thanks! :)

[@user-gf9of9lc7c]

Look up how to make templates, once you have a template customized for you, you can get to making soft quickly

[@sheenclean6541]

thanks this really helped!!!

[@solotch2804]

Thank you sir!

[@drahomirmichalko]

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.

[@drahomirmichalko]

nevermind, solved. The issue was with the secondary axis tick box, when I unchecked it, the datapoints showed up.

[@Timgroschkeprivat]

Thanks , thats good stuff

[@nermeenbastawy1709]

amazing... thank you

[@martinemallyon7037]

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?

[@andrewleynes9726]

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.

[@smsabbiralam8514]

Wonderful.

[@yeasmeenali3423]

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?

[@andrewleynes9726]

Same as in the example. You will have more rows of data and more data points.

[@TR_Conqueror]

@@andrewleynes9726 If you have 20 values just go ahead and use box-plot... Why bother yourself with all this mess..

[@osio9737]

Legend

[@qm6595]

how would you connect the data points in a paired data set?

[@andrewleynes9726]

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.

[@diadiaa892]

Toooo helpful! Thank you v much my man🫶🏾