For example, you could show line graphs for temperature and humidity on top of each other. For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis.

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