How to Create a Scatter Chart in Excel (with Easy Steps)

Scatter charts are usually used to find relationships between two or more variables. It is also known as the XY Scatter Chart. In this post, you will learn how to create a Scatter Chart in Excel.


Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


Step-by-Step Procedures to Create a Scatter Chart in Excel

You know, business data analysis has so many goals. One of the goals is to find out the hidden relationships between values. XY Scatter Plot is one of the best solutions.

A scatter chart can be created easily by using the Insert tab. You need to follow the steps below to create a Scatter Chart in a simple and easy manner. For the purpose of demonstration, we have used the following sample data.

How To Create A Scatter Chart In Excel


Step 1: Arrange Dataset for Scatter Chart

For example, say you run a little store in your town. Many of your customers come from farther distances, and some of them live near your store. You want to run a survey on your customers to find out whether those who come to your store from a farther distance shop more than those who come from nearby places. Say you have found the following data from your survey. In the following steps, we will arrange the following data set with two variables in order to create a Scatter Chart in Excel.

  • On the left, you get the Distance column, and on the right, you get the Amount spent.
  • Distances are measured in miles per unit, and amounts spent are in dollars. To get relationships between two variables, we will use the XY data series.

Read More: How to Format Data Series in Excel (with Easy Steps)


Step 2: Utilizing Charts Group to Create a Scatter Chart for 2 Variables

Now, we will draw a scatter chart for two variables. Follow the below steps to create a Scatter Chart smoothly in Excel.

  • Firstly, select any cell within the data.
  • Then, click the Insert tab.
  • Next, from the Charts group of commands, click on the Scatter (X, Y) command.
  • A drop-down menu will appear; select the first one, simply the Scatter chart.

Create Scatter Chart in Excel

  • Then, select the chart and click on the (+) symbol.
  • After that, click on the Chart Elements below.

  • Finally, you will get a Scatter chart like the following image. The X-axis represents the distance in miles, and the Y-axis represents the amount spent.

Read More: How to Group Data in Excel Chart (2 Suitable Methods)


Similar Readings


Visualizing Scatter Chart with Multiple Designs

The Scatter Chart command of Excel contains multiple designs. It includes Scatter, Scatter with Smooth Lines and Markers, Scatter with Smooth Lines, Scatter with Straight Lines and Markers and Scatter with Straight Lines. All of them are Scatter Charts showing various types of visualization. Now, I will demonstrate how to create multiple design Scatter Charts in Excel.

1. Scatter with Smooth Lines and Markers

  • Again, click on the Scatter command from the Charts group.
  • Now, choose Scatter with Smooth Lines and Markers from the Scatter Chart command.

Create Scatter Chart with Smooth Lines and Markers

  • Finally, a Scatter Chart will be created automatically.

2. Scatter with Smooth Lines

  • From the Insert tab, click on the Scatter (X, Y) It is in the Charts group of commands.
  • Now, click Scatter with Smooth Lines.

Create Scatter Chart with Smooth Lines

  • A Scatter chart showing smooth fine lines will be generated.

3. Scatter with Straight Lines and Markers

  • From the Charts collection of commands, select the Scatter command.
  • Select Scatter with Straight Lines and Markers.

Create Scatter Chart with Straight Lines and Markers

  • This will provide a Scatter Chart with straight lines and markers.

4. Scatter with Straight Lines

  • Firstly, select Scatter (X, Y)  from the Charts group of commands.
  • Then, click Scatter with Straight Lines from the Scatter Chart command.

Create Scatter Chart with Straight Lines and Markers

  • Now, a Scatter chart will be created like the following image.


Creating Scatter Plot with 3 Variables in Excel

Additionally, Scatter Plots can be drawn easily for three variables in Excel. It establishes a relationship between three variables. The process is almost the same as the process we followed earlier to create a scatter plot in Excel for three variables.

Steps:

  • Click on any cell within the sample data.
  • Now, click the Insert tab.
  • Afterward, from the Charts group of commands, select the Scatter command.
  • Finally, select the first one from the drop-down menu, which is the Scatter chart.

Create Scatter Chart for Three Variables in Excel

  • After that, select the chart and click on the (+) symbol.
  • Then, click on the desired Chart Elements.
  • Finally, you will get the desired Scatter chart.


Discussion

On the chart, it is clear that there is a relationship between distance and the amount spent. You can see from the chart that people who come to the store from farther distances shop more. Moreover, a person who comes from a distance of 0 to 20 miles shops for between 0 and 50 dollars. When customers’ distances are between 40 and 60 miles, they shop for between 35 and 125 dollars. The higher the distance, the range is also higher.

The scenario makes sense. If you live close to a store, you are able to make frequent small purchases every time you go to the store. But in most cases, large department stores are not available around your residence. So when you finally go there, you will spend more money because you cannot make frequent visits to a long department store. This Scatter (X, Y) chart shows you that relationship easily.

So using Scatter Chart in Excel, you can easily show the relationships between two data series.

Read More: How to Plot Time over Multiple Days in Excel (With Easy Steps)


Conclusion

These are all the steps you can follow in Excel to create a Scatter Chart in Excel. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

For more information like this, visit ExcelDemy.com.

This is a sample lecture of my course: Data Analysis in Excel with Statistics: Get Meanings of Data where you will learn Data Analysis with 52 case studies, problems, and their solutions!

Related Articles

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo