How to Make a Scatter Plot in Excel?

Affiliate disclosure: In full transparency – some of the links on our website are affiliate links, if you use them to make a purchase we will earn a commission at no additional cost for you (none whatsoever!).

Do you know what is a scatter plot?? Wondering how to make a scatter plot in excel? If so, then stay tuned! In today’s article, we are going to learn how to make a scatter plot with step by step guide. But before that let’s check out what actually scatter plot is.

A scatter plot is a graph in which the values of two variables are plotted along with two axes. A scatter plot is also known as a scatter diagram that is represented on the graph as a cross or a dot. A scatter plot is a two-dimensional graphical representation of a set of data.

A scatter plot is commonly used for scientific data as it shows the relationship between the numeric values in diverse data series. With the help of a scatter plot one can easily show the uneven or clusters of data as well.

Scatter charts and line charts are quite similar especially when a scatter chart is displayed with the lines. Creating a scatter chart is very easy in MS excel. If you have been reading our articles, you must have read our previously written article on creating graphs in Excel. Where I had thoroughly explained the procedure of creating charts and graphs in excel with step by step procedure.

If you know how the graphs and charts are created in MS Excel, then it will hardly take any of your time to learn the scatter plot excel.

And if you haven’t read the article or don’t know how to create graphs in excel still not to worry, along with the excel scatter plot I will also give you some hints regarding the charts and graphs in excel.

How to Make a Scatter Plot in Excel

To start making a scatter in excel you will need to follow the given steps carefully. Read out the complete guide carefully and learn to make a scatter plot in excel. Only a few steps to follow and you are done. Now let’s not waste much time and head over to the guide!!

Step 1: First of all launch the MS excel program to the system.

Step 2: After you have opened up the excel program fill out the data you would like to create a scatter plot of. Put the data in rows and columns as per the suitability and requirement. Considering you already know need to tell you much about the rows and column, moving to the next step.

Step 3: After filling up the rows and columns, select the area you want the scatter plot of. Check out the below screenshot if you don’t understand how the data should be selected.

Step 4: Now once you have selected the area and the data click on the Insert menu from the menu bar. After clicking on the insert menu you will see some options there like Column, Line, Pie, Bar, Area, Scatter and other charts. These are the various types of charts and graphs. You can select any of them if your requirement fits the need.

Like if you want a Pie chart then without thinking much select the Pie, similarly if you want the line chart or column chart select that. But as we are about to create a scatter plot we will need to go to the Scatter option.

Step 5: Now without thinking much, click on the scatter option. As sooner you will click on the Scatter option, a small drop-down list will appear just right there. This is what we have come for. Now select any of the scatter by clicking on the particular scatter. I have managed to grab a screenshot for you. Have a look at that.

Step 6: As you can see in the above screen there are five scatter appearing. Select any of them you want. After you will select any scatters, the data you have selected would turn into a scatter plot. Look at the below-mentioned screenshot. 

In the above screen, I have titled three columns a day, months, and years and in the rows, I have put some random data. However, I have also mentioned the screenshot to make things easy for you but in case if you are still not able to get any step you can ask in the comment section.

If you want other than the above scatter plots click on the All Chart Types…. Once you click on the All Chart Types, a small window will be opened up. Look at the screenshot.

As you can see on the left side of the screen there are various types of charts appearing including the XY (Scatter). If you want to switch the scatter plot to any other chart select from the list and your chart type will be changed immediately. You can also manage the templates by clicking on the Manage Templates.

The above method I described and the screenshot I took was from Microsoft office 2007. If you are using Microsoft office 2003 then you might face a little difficulty in finding the option. However, both the versions are almost the same but in case if you are not able to find the option check out the below-mentioned steps.

Step 1: As mentioned in the above step, fill out the data you want to create a chart of.

Step 2: After you have entered the data in rows and columns select all of them by dragging over it. Once the data are selected click on the Insert menu from the top menu bar. That’s it. After you select the insert menu, you will see, there is not much difference in the steps ad procedure described above. Now simply follow the above steps and create a scatter plot of the data you want.

So this was how to make a scatter plot in the excel program. I hope you have clearly learned the method. In case, of any doubt, confusion or suggestion you can drop the comment in the comment section. We will try to reach out to you as soon as possible.

If you liked and enjoyed the guide you can also consider sharing that on social media accounts. We will highly appreciate that.

sonam

Leave a Comment