Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Display the R-squared value for a trendline
Click the trendline for which you would like to display the
(R-squared value: A number from 0 to 1 that reveals how closely the estimated values for the trendline correspond to your actual data. A trendline is most reliable when its R-squared value is at or near 1. Also known as the coefficient of determination.)
Display R-squared value on chart
You cannot display an R-squared value for a moving average.