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 a line chart, Microsoft PowerPoint 2010 can help you plot your line graph on any of the slides that make up your presentation. ... How to Graph Linear Lines in Microsoft Excel.

To add a regression line, choose "Add Chart Element" from the "Chart Design" menu. In the dialog box, select "Trendline" and then "Linear Trendline." To add the R 2 value, select "More Trendline ...

Two graphs are shown above, one displaying the regression line with values from the training dataset and one with values from the test dataset. The green points of the scatter plot (for the test graph ...