How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers.

How to create a Scatter Plot in Excel The procedure to create a scatter plot in Excel is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Scatter Plot.

The legend on an Excel scatter plot is simply a list of the names for each of the series on the chart. The legend is color coordinated, so you can quickly determine which data points belong to ...