Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Syntax
expression. DisplayRSquared
expression A variable that represents a 'Trendline' object.
Remarks
Setting this property to True automatically turns on data labels.
Example
Note
Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.
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 2D 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
See also
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.