How do I fit a non-line-of-best-fit linear function to a scatter plot?

[Empiral]

Hello all! I am wondering if there is a way to fit a linear function that is not the line of best fit to a scatter plot, and calculate the R-value of that line.

[MrShorty]

I am not certain exactly what your question is. I don't believe there is any way to have the chart trendline feature computer r^2 for anything but the best fit regression that it performs. However, this computation should be easily performed in the spreadsheet using Excel's built in statistical functions: https://support.office.com/en-us/art...__toc309306716 I would expect you to use what you know of how to calculate Pearson coefficient and r^2 using your desired known_y's and estimated_y's. You may find the Pearson(), rsq(), or other functions useful.