Microsoft Excel 2013 enables you to add sets of data to a chart one at a time. If your data is in the proper order, however, you can plot both sets of data at the same time.

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