Applies To
Trendline Object.
Description
True if the point where the trendline crosses the value axis is automatically determined by the regression. Read-write.
Remarks
Setting the Intercept property causes this property to be set to False.
See Also
Intercept Property.
Example
This example causes Microsoft Excel to automatically determine the trendline intercept point for Chart1. The example should be run on a 2-D column chart that contains a single series with a trendline.
Charts("Chart1").SeriesCollection(1).Trendlines(1).InterceptIsAuto = _
True