The Trendlines collection holds the collection of trendlines in a chart. Each Trendline object describes a trendline on a chart of a particular series. Trendlines are used to graphically show trends in the data and help predict future values. The parent of the Trendlines collection is the Series object.
The Trendlines collection has one method besides the typical collection attributes. The Add method adds a trendline to the current chart. The Add method has a Type, Order, Period, Forward, Backward, Intercept, DisplayEquation, DisplayRSquared, and Name parameter. See the "Trendline Properties" section for more information.
Was this article helpful?