Trendline.InterceptIsAuto Property (Word)

True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean .


expression. InterceptIsAuto

expression A variable that represents a 'Trendline' object.


Setting the Intercept property sets this property to False .


The following example sets Microsoft Word to automatically determine the trendline intercept point for the first chart in the active document. You should run the example on a 2-D column chart that contains a single series that has a trendline.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.SeriesCollection(1).Trendlines(1) _ 
 .InterceptIsAuto = True 
 End If 
End With

See also

Trendline Object