Making Scatter Plots/Trendlines in Excel

About this tutorial:

Video duration: 12:3
The title says it all! Check out my Channel at for more videos on Statistics and Economics.

If you like what I am doing, please consider supporting this effort on Patreon or buy me a cookie through PayPal!

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

20 thoughts on “Making Scatter Plots/Trendlines in Excel

    Thomas Cho

    (February 16, 2020 - 3:25 am)

    When you plug it in, the left side becomes highlighted with purple, then the right side is blue (title is red). When I plug it into a scatterplot the points become highlighted horizontal purple and blue not vertically. For example, when I graph it, instead of getting all blue points, I get like 40 different colored points. Can someone tell me what I'm doing wrong.

    Mike Zou

    (February 16, 2020 - 3:25 am)

    Stupid. I didn't use this version!

    Molly Thompson

    (February 16, 2020 - 3:25 am)

    these video tutorials really saved my bacon at work! Thanks for the tutorials

    leto B

    (February 16, 2020 - 3:25 am)

    You instructions are so clear! Thank you very much.

    Syed Zaman

    (February 16, 2020 - 3:25 am)

    U sound exactly like sal khan

    Refl3x Pie

    (February 16, 2020 - 3:25 am)

    I did what you did but i always got a plot with nothing on it

    Mike Song

    (February 16, 2020 - 3:25 am)

    Question: What if you want to know which car a particular dot is attributed to? So for example, can we add a label that somehow references the source of that data?

    Anna Dmitrieva

    (February 16, 2020 - 3:25 am)

    Thank you so much for the tutorial. However my Excel sheet doesn't save charts. What can possible reason be? TIA


    (February 16, 2020 - 3:25 am)

    thanks a lot

    Freddie Wooten

    (February 16, 2020 - 3:25 am)

    Can a shape be added? Example the USA country.

    Mehta Pratik

    (February 16, 2020 - 3:25 am)

    Thankyou so much sir, this video was very much helpful for finishing my University homework

    Tony Wheeler

    (February 16, 2020 - 3:25 am)

    This video was very helpful! Thank you.


    (February 16, 2020 - 3:25 am)

    You sound like tom hanks


    (February 16, 2020 - 3:25 am)

    Whenever I choose a graph and click on it, it always show me a blank page/chart it annoys me so much and I try to put stuff in but I can only change the colour of the page….


    (February 16, 2020 - 3:25 am)

    You seem like you know what youre doing, how would i make a brinley plot in excel for age variation?

    sandesh ratnayake

    (February 16, 2020 - 3:25 am)

    Thankyou very much …. this video is very useful

    Guilherme Charrua de Sousa

    (February 16, 2020 - 3:25 am)

    Hey, when I try to make the scatterplot the data gets mixed up and the one that said "HP" on yours (the red square) is one of the numbers and everything gets mixed up. What do I do? Thank you!

    Anusha Goonasekera

    (February 16, 2020 - 3:25 am)

    OMG u sound exactly like John Quiñones has anyone told u that 😱

    Yasir Shakeer

    (February 16, 2020 - 3:25 am)

    hello sir …please I have a question …if I need to know the x and y for specific point in scatter and know the exact location of this point (x,y) like the row number and collum….how can I do this??


    (February 16, 2020 - 3:25 am)

    r u Andrew FLOST? OH MY GOD!

Leave a Reply

Your email address will not be published. Required fields are marked *