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

These charts can help with presenting the information more professionally. To make them even better, you can add a trendline in these charts, which can be further customized as per your needs. In this ...