One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.

To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart. Select the appropriate line chart.

These instructions apply to Excel 2013 but also function similarly for Excel 2010. The chart features are the same between the two, but the main start screen has been updated for Excel 2013.

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.