![]() The default value is False.ĭisplayRSquared Optional Variant. True to display the equation of the trendline on the chart (in the same data label as the R-squared value). ![]() If this argument is omitted, the intercept is automatically set by the regression.ĭisplayEquation Optional Variant. The number of periods (or units on a scatter chart) that the trendline extends backward. ![]() The number of periods (or units on a scatter chart) that the trendline extends forward.īackward Optional Variant. Must be an integer greater than 1 and less than the number of data points in the series you're adding a trendline to.įorward Optional Variant. Must be an integer from 2 to 6, inclusive. Can be one of the following XlTrendlineType constants: xlLinear, xlLogarithmic, xlExponential, xlPolynomial, xlMovingAvg, or xlPower. An expression that returns a Trendlines object. Returns a Trendline object.Įxpression.Add(Type, Order, Period, Forward, Backward, Intercept, DisplayEquation, DisplayRSquared, Name)Įxpression Required. Here the cut and paste of the VBA help in order you do not have it installled.Ĭreates a new trendline.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |