*138*

Table of Contents

In this article we will show you how to Make Scatter Plot in Excel. You can show your data clearly in Microsoft Excel by using a chart. This makes it easy for your audience to see a view of your data that is beautiful and often more useful. A scatter plot is a type of chart in Excel that many people don’t think about. It is also called a scatter graph, scatter diagram, and scatter chart. With this kind of picture, you can compare two sets of data by plotting points.

Microsoft Excel has a few different types of scatter plots that you can use to show your data. Let’s look at each of them and see how to make a scatter chart in Excel. The scatter plot is a two-dimensional graph that is also called the scatter diagram or the XY graph. It is used to show the link between two variables (axes), such as the X-axis and the Y-axis.

The horizontal axis is called the X-axis, and the vertical axis is called the Y-axis. It shows the link between two variables, or how a change in one variable affects the other. Scatter plot graphs are the most important way to show data for regression analysis. But you might be curious about how to Make Scatter Plot in Excel. Keep reading this piece with facts to find out how. If you want to know more information about this visit official Microsoft Excel Website.

## What is Scatter Plots?

People use scatter charts to figure out how two pieces of data are related to each other. A scatter plot is made up of dots. Each dot indicates two values (one on the X-axis and one on the Y-axis), and the dots are placed in the chart based on these values. In the real world, this could be shown by the marketing costs and sales of a group of companies in the same business. When we plot this data (Marketing Expense vs. Revenue) on a scatter chart, we can see how closely or weakly these two variables are linked.

## How to Make Scatter Plot in Excel

### Prepare your data

**Before**creating a scatter plot, you need to have your data**organized**in**columns**.- Each column represents a
**variable**. - For instance, if you want to compare the
**relationship**between the**height**and**weight**of**individuals**, you would have two columns: one for**height**values and another for**weight**values.

### Select the data

- The data points you want to include in your
**scatter plot.** - To select both the
**x-axis**(independent variable) and the**y-axis**(dependent variable) data.

### Insert the scatter plot

- Navigate to the “
**Insert**” tab in Excel’s ribbon menu. **Locate**the “**Charts**” group.**Click**on the “**Scatter**” chart type.**Choose**the desired scatter plot style from the available options.- You can select a simple scatter plot or
**opt**for variations like scatter plot with straight lines, smooth lines, or markers only.

### Customize the scatter plot

**Once**the scatter plot is inserted, you can**customize**it to enhance**readability**and**clarity**.**Right-click**on the**plot area**or the**individual data points**to access various**formatting**options.- You can
**modify**the**axis labels**,**add**a**chart title**,**adjust**the**axes’ scaling**,**change****colors**, and**more**.

### Add trendlines

- Trendlines aid in
**analyzing**the**overall trend**or**pattern**in your**scatter plot**. - To
**add a trendline**,**right-click**on a**data point**. - Select “
**Add Trendline”**. **Choose**the**desired type**of trendline (**linear**,**exponential**,**logarithmic**, etc.).- The
**trendline**can**provide****additional insights**into the**relationship**between the**variables**.

### Add data labels

**Data labels**can be useful to identify specific**data points**in your**scatter plot**.- To
**add data labels**,**right-click**on a data point. **Select**“Add Data Labels.”**Choose**the appropriate**labeling option**.

### Analyze the scatter plot

**Create**the scatter plot.- Carefully analyze the
**data points**and**look for**any**observable patterns**,**trends**, or**relationships**between the**variables**. **Consider**the**distribution**of**data points**and the**direction**of the**scatter plot**.**Interpret**the**findings**based on your**specific research question**or**objective**.

**After analyzing**and**interpreting**the scatter plot, it’s**essential**to**save**your work.- Go to the “
**File**” tab and select “**Save**” to save the Excel file. - If you need to
**share**the scatter plot with others who may not have Excel, you can also**export**it as an**image file**(e.g.,**PNG**or**JPEG**) or**copy**it as an**image**to be**pasted**into other applications.

## Common Issues with Scatter Plots in Excel

**Incorrect layout of data:**Scatter plots need two sets of numbers, one set for the values on the x-axis and the other set for the values on the y-axis. Before making the scatter plot, make sure your data is set up properly.**Missing or incomplete data:**If there are missing or incomplete data points on either the x-axis or the y-axis, Excel may not plot them properly or may leave them out of the scatter plot. Make sure your data is full and that no values are missing.**Scaling of axes is wrong:**Excel scales the axes automatically based on the data range, but sometimes the scaling isn’t right for the data being drawn. Change the scale of the axes so that the data points are easy to see and not too close together or too far apart.**Misinterpretation of data: S**catter plots show how two factors are related to each other. Make sure you use the right variables for the x-axis and y-axis to show the relationship you want to study correctly.**Excel has different kinds of scatter plots:**such as simple scatter plots, scatter plots with smooth lines, and scatter plots with only marks. If you choose the wrong type of plot, you might misunderstand the data or have trouble seeing how the factors are related.**When there are a lot of data points:**they can cross or get messy, making it hard to understand the scatter plot. Consider using names or other ways to show the data, like adding trendlines or grouping the data points, to make it easier to understand.

## Questions and Answers

**How to create a scatter plot?**

Put the independent variable on the left side of the graph and the dependent variable on the right. Put a dot or a symbol where the x-axis value meets the y-axis value for each pair of data. (If two dots fall together, place them next to each other so you can see both of them.)

**How do I plot 3 variables in Excel?**

Step 1: Open the Excel sheet and type in the numbers for three variables. Give the variables names and save the changes. Step 2: Select everything, including the headers, and open the Insert tab in the navigation menu. Step 3: Find the charts session and click on the bar graphs button.

**What is a simple scatter plot?**

Scatter plots are the graphs that show how two factors in a set of data are linked. It shows where points of data are on a two-dimensional plane or a Cartesian grid. The X-axis shows the independent variable or characteristic, and the Y-axis shows the dependent variable.

**What is a scatter plot example?**

With a certain confidence range, a scatter plot can show different kinds of links between variables. For instance, weight and height would be on the y-axis, and height would be on the x-axis. Correlations can be positive (going up), negative (going down), or null (going in different directions).