Skip to content

Latest commit

 

History

History
37 lines (24 loc) · 926 Bytes

Excel.Intercept.md

File metadata and controls

37 lines (24 loc) · 926 Bytes
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Intercept property (Excel Graph)
vbagr10.chm65722
vbagr10.chm65722
Excel.Intercept
9c7c4193-8f9d-0f33-74c7-055a9124320e
04/11/2019
medium

Intercept property (Excel Graph)

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

Syntax

expression.Intercept

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

Setting this property sets the InterceptIsAuto property to False.

Example

This example sets trendline one to cross the value axis at 5. The example should be run on a 2D column chart that contains a single series with a trendline.

myChart.SeriesCollection(1).Trendlines(1).Intercept = 5

[!includeSupport and feedback]