Look at the following image which represents the scatter plot with two sets of data.
If you have fewer data points, you can choose other scatter plot types too.In this case, we have chosen the first one. Now, select a suitable scatter plot template.From the Chats group, click on the Insert Scatter (X, Y) or Bubble Chart button.Read More: Use ScatterĀ Chart in Excel to Find Relationships between Two Data Series Avoid selecting any column other than these. Next, you have to select the two columns including their headers. Place the independent variable in the left column, and the dependent variable in the right column. Therefore, you have to enter the two sets of numeric data in two separate columns. Remember that a scatter plot displays two interlinked numeric variables. The first task here is to arrange the data properly. We will try to find the correlation between them with the help of this diagram. The following data have price info of crude oil and gas in the U.S.A.
#How to plot a graph in excel with two sets of data how to
Now we will learn how to make an Excel scatter diagram with two sets of data. Steps to Make a Scatter Plot in Excel with Two Sets of Data Read More: How to Make a Correlation Scatter Plot in Excel (2 Quick Methods)