In the dialog box, select "Trendline" and then "Linear Trendline." To add the R 2 value, select "More Trendline Options" from the "Trendline" menu. Lastly, select "Display R-squared value on chart." ...

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.

A trendline in Excel is a line that shows a general trend ... By default, Excel inserts a linear trendline. However, you can add other variations of your choice like, Exponential; ...

How to Graph Linear Equations in Excel 2007. ... selecting the "Trendline" drop-down box and clicking "Trendline Options." Select the "Linear" option and click the "Display Equation on Chart" box.

In the dialog box, select "Trendline" and then "Linear Trendline." To add the R 2 value, select "More Trendline Options" from the "Trendline" menu. Lastly, select "Display R-squared value on chart." ...