ExcelChartTrendline Properties
From Office Open XML
The ExcelChartTrendline type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
| Backward |
Forcast backwards periods
| |
| DisplayEquation |
Display the trendline equation on the chart
| |
| DisplayRSquaredValue |
Display the R-squared value for a trendline
| |
| Forward |
Forcast forward periods
| |
| Intercept |
Specify the point where the trendline crosses the vertical axis
| |
| Name |
Name in the legend
| |
| Order |
Order for polynominal trendlines
| |
| Period |
Period for monthly average trendlines
| |
| Type |
Type of Trendline
|