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.

Add a linear regression line to the scatter chart by clicking the "Layout" tab, selecting the "Trendline" drop-down box and clicking "Trendline Options." Select the "Linear" option and click the ...