Default is a brief, generated description of the trendline. The text to display in the chart legend for the trendline. True displays the trendline R-squared value as a data label False does not. True displays the trendline formula as a data label False does not. If this argument is omitted, the intercept is automatically set by the regression.
The number of periods or units to project the trendline backward beyond the plotted series.
The number of periods or units to project the trendline forward beyond the plotted series. Can be one of these settings: xlExponential, xlLinear (default), xlLogarithmic, xlMovingAvg, xlPolynomial, or xlPower.įor polynomial trendlines, the trendline order from 2 to 6.įor moving average trendlines, the number of data points to include in the average. An xlTrendlineType constant indicating how the trendline is calculated.
0 kommentar(er)
