title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Trendline.InterceptIsAuto property (Word) |
vbawd10.chm26345659 |
|
|
71abda4e-9de5-71a0-1f0c-f7f81d7e024c |
06/08/2017 |
medium |
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 2D 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
[!includeSupport and feedback]