Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. SeriesCollection(1).Trendlines(1).Type = xlMovingAvg Trendlines(1) is the first trendline added to the series, and Trendlines(Trendlines.Count) is the last one added. The index number denotes the order in which the trendlines were added to the series. Select Add Trendline Check Display Equation on Chart Now we know that the data set shown above has a slope of 165.4 and a y-intercept of -79.85. When you need to get a quick and dirty linear equation fit to a set of data, the best way is to simply create an XY-chart. If the series has no trendline, this example will fail. Simple Linear Regression with Excel Charts. The following example changes the trendline type for the first series in embedded chart one on worksheet one. Use Trendlines ( index), where index is the trendline index number, to return a single TrendLine object. Trendlines.Add type:=xlLinear, name:='Linear Trend' Worksheets('sheet1').ChartObjects(1).Chart.SeriesCollection(1) _ The following example adds a linear trendline to the first series in embedded chart one on Sheet1. Use the Add method to create a new trendline and add it to the series. MsgBox Charts(1).SeriesCollection(1).Trendlines.Count The following example displays the number of trendlines for series one on Chart1. Use the Trendlines method of the Series object to return the Trendlines collection.

A trendline shows the trend, or direction, of data in a series.

RemarksĮach Trendline object represents a trendline in a chart.

A collection of all the Trendline objects for the specified series.

Excel chart trendline equation