You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

Lastly, plot charts, often called scatter or line graphs, are ideal for visualizing relationships between two continuous variables.

Click on XY Scatter to generate a curved graph in Excel. A window of options will open to setup the final graph. Make sure you have mapped Column A to the X Axis and Column B to the Y Axis.

Each of these new column pairs will be used to plot a series of smaller concentric bull’s-eye circles. When plotted on an Excel Scatter Chart, these data points will form a total of four circles, ...