Launch Microsoft Excel 2010 and open the spreadsheet that contains the hidden lines. Press the "Ctrl-A" keys to select the entire spreadsheet. Press the "Ctrl-Shift-(" keys together to expand all ...

In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an ... if you have more, increase the ranges.

You would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel. By doing this ...