A scatter plot is just one style of chart-making in Excel. If you find that you need more flexibility in the presentation, you can right-click on the chart and select Change chart type .

If you're relatively new to Excel, entering a formula is quite easy, even if you have a lot of data. First, highlight the first cell where you want the answer to the formula to appear in.

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. Adding Data Sets One ...