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 .

For example, if you are plotting stock prices over time, you can use a line graph or a scatter plot. This set of data is labeled as "Series 1." Right-click a blank space on the chart, click ...