How To Make A Scatter Plot In Excel

6.2 min read|Last Updated: January 29th, 2024|Categories: excel|
table of content

One of the comparator charts in Excel is the Scatter chart.

What is the Scatter Chart?

The Scatter chart (XY graph or Scattering plot) is a 2D chart that compares the relevance of two sets of data. Both of the scatter axes contain numeric values.

What is scatter chart in Excel?
Picture 1- The Scatter chart on Excel

 

When to Use the Scatter Plot?

In this tutorial, we learn how to create a scatter plot based on our data.

As we mentioned, the scatter plot shows the dispersion of numerical data sets and displays the correlation between them. So we have two sets of numbers in two columns.

Creating a Scatter chart

Before you create the scatter chart, you should arrange the numbers. To arrange the data in Excel, follow these steps:

  1. Select the data set.
  2. Go to the Home tab from the ribbon.
  3. Click on the Sort & Filter button from the Editing group.
  4. You have two options (better to select “sort smallest to largest”):
  • Sort smallest to largest
  • Sort largest to smallest

Now your data is sorted.

How to sort data in Excel? https://bsuite365.com/exce
Picture 2- Sort the data in excel

 

We have an example of the price of the tutorial package and price.

To create the scatter chart according to the example. Follow the steps below:

  1. Select the data.
  2. Go to the Insert tab from the menu bar.
  3. Select the scatter icon from the Charts group.
  • There is no scatter icon! Click on the little arrow at the bottom of the chart group to see all charts.
  • When the Insert Chart dialogue box opens, go to the All Charts tab, select the X Y (scatter) and try the charts to find the right one.
  1. We chose the first chart   for this example.

There are some things to keep in mind to make sure your chart works well:

  1. You should enter quantitative data.
  2. The data should be in two sets in two separate columns.
  3. The independent variables should be in the left column (because these variables will be plotted on the X-axis.)
  • If you didn’t follow this, click on the chart area, go to the Design tab from the ribbon, click on the Switch Row/Column button .

Also, you can add axes titles, change the axes units, and other axes options.

To add axes titles, click on the chart area, click on the Chart Elements button