Display the R-squared value for a trendline

  1. Click the trendline for which you would like to display the R-squared value (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.).
  2. On the Format menu, click Selected Trendline.
  3. On the Options tab, select Display R-squared value on chart.

 Note   You cannot display an R-squared value for a moving average.