How to Make a Scatter Plot in Excel with Two Sets of Data (in Easy Steps)

The sample dataset covers prices for crude oil and retail gas in the U.S.A. over a 12-month period.

Make scatter plot with two sets of data: Sample dataset

Step 1 – Arrange Data Properly

The first step is to organize your data. Remember that a scatter plot displays two interlinked numeric variables. So, you need to enter the two sets of numeric data in two separate columns. The variables are of two types. Put the independent variable in the left column and the dependent variable in the right column.

Arrange two sets of data to make a scatter plot

Step 2 – Select Data

Select the two columns including their headers.

Select two sets of data

Step 3 – Create Scatter Plot

Go to the Insert tab.
From the Chats group, click on the Insert Scatter (X, Y) or Bubble Chart button.
Select a suitable scatter plot template. We chose the first one.
If you have fewer data points, you can choose other scatter plot types too.

Create scatter plot with two sets of data

It will output the scatter plot with two sets of data.

Scatter plot

Step 4 – Customize the Graph

Edit Chart Title:

Double click on the chart title and add your desired title (e.g., Crude Oil vs Retail Gas Price).

Format Vertical/Horizontal Axis:

To remove the white space around the data points, we can format the X and Y axis changing the starting point of the graph. In this graph, 68.52 is the first value along the X-axis. But the graph starts from zero point.

Click on the chart area and go to the Format tab.
Click on X-axis. A side window will appear on the right.
From the Format Axis window, click on the Axis Options button and then click on the Axis Options drop-down menu.

Scatter plot vertical and horizontal axis formatting

Input 60 in the Minimum box and 120 in the Maximum box located in the Bounds section. Press ENTER.

The graph will look like the image below.

scatter plot in excel with two sets of data

Format the Y-axis following the same procedure.

scatter plot in excel with two sets of data

Add Data Labels:

Click on the scatter plot and click on the Chart Elements button.
Click on the Data Labels drop-down >> More Options.

The graph will look like this.

Note:

For scatter plots with just a few data points, adding data labels can be helpful. But if your graph has a lot of points, data labels can get crowded.

You can add more formatting with the options in the following window.

Add Trendline and Equation:

Click on the chart area and then on the Chart Elements button.
Check the Trendline box.
From the Trendline drop-down, select More Options to add formatting to the trendline.

To add a Correlation Equation to the graph, go to the Format Trendline window as described above and check the Display Equation on the chart box from the Trendline Options section.