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.

The resulting chart needs to automatically update to reflect the new average. Fortunately, Excel automates most of these tasks as long as you set up your spreadsheet correctly. How to Add Data in ...