Syntax

expression.InterceptIsAuto

expression A variable that represents a Trendline object.

Remarks

Setting the property sets this property to False.

Example

This example sets 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.

Visual Basic for Applications 
Charts("Chart1").SeriesCollection(1).Trendlines(1) _ .InterceptIsAuto = True
Calculate y intercept automatically? intercept intercept is auto Intercept Is Auto Property interceptis InterceptIsAuto InterceptIsAuto Property Place trendline automatically?

See also: