An X-Y scatter chart is an ideal plot choice when you have data sets with at least two interesting variables per record, and because scatter plots are a native graph option in Excel, you simply ...

So, you want to know how to create a scatter plot in Excel. ... Because the scatter chart only plots numbers, the points and lines will be based on the columns of numbers you chose to plot.

You would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel .

How to Make a Scatterplot on Excel. A scatterplot chart graphs two related data values as a single dot by plotting one value on the horizontal X axis and the other value on the vertical Y axis.