Intercept Property

Applies To

Trendline Object.

Description

Returns or sets the point where the trendline crosses the value axis. Read-write.

For help about using the Intercept worksheet function in Visual Basic, see "Using Worksheet Functions in Visual Basic" in online Help.

Remarks

Setting this property causes the InterceptIsAuto property to be set to False.

See Also

InterceptIsAuto Property.

Example

This example causes trendline one in Chart1 to cross the value axis at 5. 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).Intercept = 5