Creating a Scatter Plot in Excel 2016

Learn how to create a scatter plot using Excel 2016. I also show how to change the scale, and draw the line of best fit.
If you want to view all of my videos in a nicely organized way, please visit mathandstatshe... . It is free for anyone to use. Please share with others you know who are struggling with math topics or statistics.
Several people ask what microphone and writing tool I use to make the videos. As an Amazon Associate, I earn from qualifying purchases.
Samson Go Mic Portable USB Condenser Microphone: amzn.to/31Djm2f
Monoprice 10 x 6.25-inch Graphic Drawing Tablet (4000 LPI, 200 RPS, 2048 Levels): amzn.to/2Z9UJZ7

[@LuckyZap]

finally an instructional video with a proper mic

[@OneTwoMark]

I was trying to figure something out for a while, using AI as help. But 2 mins into watching this video it was solved. Shows that real humans still outclass AI in some things. Cheers.

[@themeatballman3746]

Thank you so much! I was struggling with my math assessment but now I'm all set!

[@_axxce]

thank you for this tutorial finally I can make a proper graph instead of it draw it manually. God bless you

[@Pralyth]

Not sure why Microsoft apps always make simple things so complicated. Thanks!

[@joseportuondo9277]

very helpful to do assignments and home works and also it helps to understand better.

[@brandiewilliams8707]

Thank you for this information, this is a huge help with my case study for quality assurance class

[@ogouche3376]

thank you so much. You made it easier for me to write my assignment.

[@mubasheerali1174]

I love the way you speaking🤗. And thanks for the explanation😍

[@MathandStatsHelp]

You're welcome!

[@Chely0321]

Thank you so much!! You explained it perfectly💛

[@user-gm2rf6yw8k]

Short & helpful tutorial, thank you.

[@hasnainashraf2600]

Thank you so much for this! I hope you're doing well.

[@MathandStatsHelp]

You're welcome! I am well. Thank you!

[@jacubriles1423]

thank you so much this is such a simple way tp do a graph

[@MathandStatsHelp]

You're welcome!

[@diabolicesper6434]

Finally , Thank your video helps my final project ,

[@snake87931]

Very helpful, thank you

[@mervynbalfour6016]

this was exactly what I needed, thanks hay lot

[@isabellecollet1813]

Thank you 😊

[@dopilis3632]

big ups, so helpful

[@clara-qh2ie]

Thank you !!! :)

[@mohammedbaramim7639]

thank you

[@MathandStatsHelp]

You're welcome

[@aaronzwicker9393]

Thanks!

[@hotwax9376]

How would you do it if the columns weren't adjacent to one another?

[@elangelohim]

select the first column then click n hold ctrl/cmd to select the other column lol I'm probably lat...

[@o.m9514]

Thank you!!!

[@MathandStatsHelp]

You're welcome

[@noblevenom2858]

Thank you very much!

[@reduxcompletedy2641]

I am trying to do this but the only thing ı have is only one dot. How can ı solve it please help

[@kalily8184]

I don't have that right one. All I have is that left one and a vertical linear one not the right one.What do I do?

[@1981hosni]

شكرا

[@heyyyyyyyyy6887]

Hi by the way I’m new to Excel. This video help me so much but on mine I’ve got years and mass but I don’t know how to put my results on the grid ???

[@chanellex4770]

Neither x

[@lmwambetania]

Thanks Prof

[@MathandStatsHelp]

You're welcome.

[@ganyrehs]

A professor of mine said to *always* start at index 0 to avoid misleading data visuals.

[@MathandStatsHelp]

For scatter plots, I have always learned that they don't have to start at 0. It depends on the data. For graphs like histograms, it is very important that the y-axis start at 0.

[@xaidwithanx]

Thanks! This helped, a lot. :)

[@anamitra_saha]

Thanks a lot!

[@swiggityswag9583]

thx very much kind stranger

[@marinroshi1421]

Thank u so much!!!

[@MathandStatsHelp]

You're welcome!

[@SunWuJon]

Thanks so much

[@MathandStatsHelp]

You're welcome.

[@kd8136]

THANK YOU

[@cassandrapitsillides2099]

There is no quick analysis button for me :(

[@MathandStatsHelp]

Sorry some of the older versions don't have it. It's frustrating.

[@MustacheKat16]

@@MathandStatsHelp if it doesn't have it how do we get to the scatterplot

[@MathandStatsHelp]

Go to the Insert menu at the top and you should see it in the middle of the toolbar where it says charts.

[@KhaLed-pb4pu]

What if the x axis had values like 2.95 and 6.8 etc.. how can you show these specific values ( for example concentration of a certain compound) instead of showing normal scale (0-1-2-3-4- etc...)

[@MathandStatsHelp]

Typically, when there are decimals, you would still be able to do the same steps I did, and Excel will create a scale that best fits the data.

[@geraldpicard9393]

How do I eliminate the line and just leave the xy axis showing.

[@laiza8292]

what if the columns are not next to each other how do I select two different columns

[@MathandStatsHelp]

Hitting Ctrl in PC or command in Mac will allow you to select two columns that aren't next to each other. Highlight the first column, hold down Ctrl then highlight the second one. You will have to hit insert and the charts are in the center of the menu bar

[@KhaLed-pb4pu]

it took more than a second

[@maricelagutierrez816]

what if my y axis and x axis show in the middle of the chart not on the sides?

[@MathandStatsHelp]

That should be fine. If you have negative values in you data set, they would be in the middle. It depends on the context of the data which quadrants you need to see.

[@vishalbeeki5235]

nice

[@TheJoker-tm8kq]

Your voice ❤️❤️❤️❤️❤️❤️❤️❤️

[@steveistheman84]

how is the other one misleading? yours looks like a 400% increase

[@yutehube4468]

It shows people should have got tuition in 1994 😛

[@neowisek7757]

um .... um......

[@focusedalpaca42]

No help at all

[@user-dt1et6kk4o]

not very skibidi . famum tax please add some among us to your roblox

[@antoniusguntoro2052]

Thanks!