Trendline.DisplayRSquared Property (Word)
True if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Read/write Boolean.
Version Information
Version Added: Word 2007
Syntax
expression .DisplayRSquared
expression A variable that represents a Trendline object.
Remarks
Setting this property to True automatically turns on data labels.
Example
The following example displays the R-squared value and equation for trendline one of the first chart in the active document. You should run the example on a 2-D column chart that has a trendline for the first series.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
With .Chart.SeriesCollection(1).Trendlines(1)
.DisplayRSquared = True
.DisplayEquation = True
End With
End If
End With