Edit

Share via

Trendline.DisplayRSquared property (Excel)

  • Article

True if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels. Read/write Boolean.

Syntax

expression.DisplayRSquared

expression A variable that represents a Trendline object.

Example

This example displays the R-squared value and equation for trendline one on Chart1. The example should be run on a 2D column chart that has a trendline for the first series.

With Charts("Chart1").SeriesCollection(1).Trendlines(1) 
 .DisplayRSquared = True 
 .DisplayEquation = True 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.