ActiveWorkbook.Charts("Chart1").SeriesCollection(1).Trendlines.Add This example creates a new linear trendline on Chart1. If this argument is omitted, Microsoft Excel generates a name.Ī Trendline object that represents the new trendline. True to display the R-squared value of the trendline on the chart (in the same data label as the equation). 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. 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. Must be an integer greater than 1 and less than the number of data points in the series you are adding a trendline to. Must be an integer from 2 to 6, inclusive. Add ( Type, Order, Period, Forward, Backward, Intercept, DisplayEquation, DisplayRSquared, Name)Įxpression A variable that represents a Trendlines object.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |