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... ).

[@maximebrants8243]

Absolutely amazing video! You saved our bachelors thesis!

[@nreggente]

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

[@thi8a]

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

[@philipjanz9753]

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

[@rameshabt8124]

Very useful Andrew. Thanks a lot.

[@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.

[@annaireinova3195]

Thanks, this was extremely helpful!

[@kasiamyga8687]

Huge help! Many thanks! :)

[@kingabarbara1168]

this is a great tutorial! thank you!

[@Raxor191]

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

[@mohammadsalahradi2293]

Very helpful and creative.

[@sheenclean6541]

thanks this really helped!!!

[@benysmart1643]

Thank for clearly explanation

[@thangamaninmamit-civil6860]

Excellent work.

[@javierdelpino7374]

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

[@solotch2804]

Thank you sir!

[@Timgroschkeprivat]

Thanks , thats good stuff

[@smsabbiralam8514]

Wonderful.

[@nermeenbastawy1709]

amazing... thank you

[@user-gf9of9lc7c]

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

[@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.

[@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

[@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.

[@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🫶🏾