Syntax

expression.DisplayRSquared

expression A variable that represents a Trendline object.

Example

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

Visual Basic for Applications 
With Charts("Chart1").SeriesCollection(1).Trendlines(1) .DisplayRSquared = True .DisplayEquation = True End With
Display display r squared Display R Squared Property Display r-squared value as datalabel? displayr DisplayRSquared DisplayRSquared Property See r-squared value of trendline?

See also: