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.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.