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?
Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.