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

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...