How to Make a Scatter Plot in Excel

Here we come with another quick and easy video tutorial on how to make a simple scatter plot in Excel, which is useful if you want to make a visual representation of a relationship between two separate sets of data. Let’s have a look at how to do that!

Watch next video tutorial:

How to visualize data in Excel

How to Make a Graph In Excel

How to Add Chart Elements in Excel

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 Intro
0:49 How to Prepare Clear Data Table in Excel Chart
1:39 How to Make a Scatter Plot in Excel
2:32 How to Modify the Plot to Achieve the Result You Need
3:45 The Dynamic Function of the Plot

================

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)

Transcription How to Make a Scatter Plot in Excel

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[bkhudkhudia]

Your videos go to Direct in memory, once and forever. So nice presentation that it very easy to understand whatever is being explained.

[_Gondor_]

For whatever reason, when I generate the scatter plot, it’s empty. The only thing I can get to fill in is the title

[alshankp]

I enjoyed this vedio. Thnkz for a perfect presentation ☺️

[DarkFFps]

I 💕 your videos !!Best explaination😍😘👌

[jasonlai]

Great. Straight to the point. Easy to understand. Need this information because i miss 2 days of class cos of running nose. And my class mates was given an assessment to plot this chart. I was dumbfolded.

[yoongi]

wow good i always see your video and it is wonderfull

[larreldailey]

Is there a way to add in a second set of data to the same graph?

[stevena]

How do you associate the dots with the products, so that you know what product represents which dot? This is not helpful without that relationship.

[jordanmeyer]

Is there a way to label each point (say Product in this video) to clearly be able to identify each point?

[arafatfarjid]

Thank you so much! Highly appreciated. Please keep up the good work.

[william]

For some reason, every time I do this, I end up with a graph that is 1.2 units horizontally and 2 units vertically, with all of my data values at (0, 1). Could anyone explain what I might be doing wrong and perhaps have a solution?

[nielsdaemen]

My excel doesn't work like this, it wont take the data! Is this software designed to piss people off? They did a perfect job of it!

[motorshow]

Plz make a vedio on advanced excel in just vedio

[andriyvasilchenko]

1:47 This does not work. Instead of use values in first column it uses their idexes...

[venkatasaivemula]

How to convert numerical values as text formate like date year month

[ouwebok]

when i for example have 8.3 it goes to the left and it doesnt read it

[mahmoudwahbeh]

Just some constructive criticism: the first minute of the video could be cut down. No useful info was shared just stating what your colomns are which isn’t the point of the video; point of the video is how to make a scatter plot

[zipididodad]

The process shown here is trivial, i.e., select some data and press a chart option. BFD. Unfortunately, as you'll notice, the axis in the graphs shown in this "instructional video" aren't labeled. As most people with a math skill level above 6th grade will recognize, a chart without the axis labeled is pretty much useless. Well, just try to label those axis in Excel. You can left-click or right-click multiple places on the chart and open up ALL kinds of windows and specify ALL kinds of things like shadow, reflection soft edges, 3-D format, text fill, color, transparency, compound type, border, blah, blah, blah, blah, blah, ...(repeat 100 times 100 TIMES!!!!), ....YET, not once will you find a place where you can enter axis labels. Like most Microsoft programs, 99% of the people rarely use more than 1% of the bloated functionality provided. Unfortunately, that 1% of useful stuff is buried in the 99% of useless stuff.

[dans]

This graph is a waste of time. Axis are not labelled, data points are not labelled, terrible video, disliked.