Trendline.InterceptIsAuto Property (PowerPoint)
True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean.
Version Information
Version Added: PowerPoint 2007
Syntax
expression .InterceptIsAuto
expression A variable that represents a Trendline object.
Remarks
Setting the Intercept property sets this property to False.
Example
Note
Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.
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