Trendline.DisplayEquation Property (Word)

True if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Read/write Boolean.

Version Information

Version Added: Word 2007

Syntax

expression .DisplayEquation

expression A variable that represents a Trendline object.

Remarks

Setting this property to True automatically enables data labels.

Example

The following example displays the R-squared value and equation for the first trendline 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

See Also

Concepts

Trendline Object

Trendline Object Members