How to Measure R2 of Two Lines in Excel. In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an Excel formula. R2 ...

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.