InterceptIsAuto Property

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


Setting the Intercept property sets this property to False.


This example sets Microsoft Graph to automatically determine the trendline intercept point. The example should be run on a 2-D column chart that contains a single series with a trendline.

myChart.SeriesCollection(1).Trendlines(1) _ 
 .InterceptIsAuto = True