Scatter Plot in Excel | How to Create Scatter Chart in Excel?

What is the Scatter Plot Chart in Excel?

Scatter plot in excel is a two dimensional type of chart to represent data, it has various names such XY chart or Scatter diagram in excel, in this chart we have two sets of data on X and Y axis who are co-related to each other, this chart is mostly used in co-relation studies and regression studies of data.

Scatter Plots are a set of so many points on vertical and horizontal axes. Scatter charts are very important in insights since they can demonstrate the degree of connection, assuming any, between the estimations of observed quantity or values which are also called variables.

Popular Course in this category

All in One Excel VBA Bundle (35 Courses with Projects)4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

View Course

How to Make a Scatter Plot Chart in Excel?

You can download this Scatter Chart Excel Template here – Scatter Chart Excel Template

Step 1: Select the two segments in your information additionally incorporate the headers from your information.

Step 2: Tap on the Inset tab, in the Charts gathering, tap the Scatter diagram or some other as the required symbol, and select the chart which suits your information:

Step 3: Click to select the scatter plot chart which you want. After you selected the chart, you will get the chart next to your excel data table.

Step 4: Now here is your scatter plot chart after you selected the scatter chart.

Step 5: You can modify your chart as a when required, fill the hues and lines likewise of your decision. For instance, you can pick alternate shading and utilize a strong line of a dashed line. We can customize the graph as we want to customize it.

Click on the Right-click of scatter chart, click on the format data point and select the color of your diagram and customize it as required.

Step 6: Below is a scatter plot after customizing it as required:

Step 7: We can change the chart style/color, by clicking right on the chart and click on the icon as mention below screenshot:

Types of Relationship in Scatter Plots in Excel

#1 – No Correlation: This is the point when there is no direct connection between the factors. For e.g. computer and salaries have no relation between them.
#2 – Positive: This is the point at which the factors move in a similar way. For e.g. Salary and promotion, it means that when the employee gets the promotion it is so obvious that salary will get the increase.
#3 – Negative: This is the point at which the factors move in inverse ways, it means that when one variable is increases and another variable decreases. For e.g. Time spent playing badminton and time spent on studying, it means the more time a person plays it leads to study time will decrease.

Advantages

It helps to obtain the relationship between two or more variables.
A scatter plot is the best method to show the non-linear pattern.
Anyone can easily determine the minimum and maximum value on the range of data flow.
Perception and reading are so clear.
Plotting the graph is moderately basic.

Disadvantages

Scatter plot chart does not help to get the precise relationship between the variables.
Scatter plot chart is not the quantitative measure which helps to get the result in numeric.
It only gives an estimated idea of the relationship.
When data is huge, sometimes it created the mess on the scatter chart.

Things to Remember

Scatter plots in are exceptionally helpful tools for passing on the connection between two factors, however, you have to realize how to utilize them and interpret them legitimately.
The variable should be in the numeric term, otherwise, you won’t be able to create the chart.
Choose the data carefully to avoid any kind of error in analysis.
Start practicing with small data to understand the better analysis and use of scatter chart on data easily.
Always make your chart more attractive so that it shows clear information by using different colors.
If you want to communicate your data through scattering so it is mandatory to understand the audition whether they understand the data or not. If necessary make use of line on the chart which connects the points.
In some of the cases, utilizing an alternate shading for the objective information point may not be proper, so you can shade it with indistinguishable shading from whatever remains of the focuses, and afterward make it emerge by applying some other option.