Trendline.InterceptIsAuto Property

Excel Developer Reference

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

Syntax

expression.InterceptIsAuto

expression   A variable that represents a Trendline object.

Remarks

Setting the Intercept 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

See Also

• Trendline Object
• Trendline Object Members
• Intercept Property