DisplayEquation Property 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.
With Charts("Chart1").SeriesCollection(1).Trendlines(1)
.DisplayRSquared = True
.DisplayEquation = True
End With