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.

You can use an area chart to plot a single line and shaded area, but most area charts plot multiple lines (data series) so you can break down the trend between groups compared to the whole.

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab ...