Trendline.Intercept Property

Syntax

expression.Intercept

expression An expression that returns a Trendline object.

Return Value
Double

Remarks

Setting this property sets the InterceptIsAuto property to False.

Example

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

Visual Basic for Applications
`Charts("Chart1").SeriesCollection(1).Trendlines(1).Intercept = 5`

Adjust trendline position on vertical axis? intercept Intercept Property Move trendline up or down? Set trendline to cross y axis at 12 units? Where does trendline cross value axis?

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

See also: