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 ...

Select the data across both the columns (from A3 to B12). Go to Insert > Scatter Plot. Select the appropriate Scatter Plot chart. Adjust the size and location of the chart as per your requirements.