The following example uses a logarithmic trendline to illustrate predicted population growth of animals in a fixed-space area, where population leveled out as space for the animals decreased. A logarithmic trendline can use negative and/or positive values. Notice that the R-squared value is 0.9036, which is a good fit of the line to the data.Ī logarithmic trendline is a best-fit curved line that is most useful when the rate of change in the data increases or decreases quickly and then levels out.
In the following example, a linear trendline clearly shows that refrigerator sales have consistently risen over a 13-year period. A linear trendline usually shows that something is increasing or decreasing at a steady rate. Your data is linear if the pattern in its data points resembles a line. If you want, you can display this value on your chart.Ī linear trendline is a best-fit straight line that is used with simple linear data sets. When you fit a trendline to your data, Graph automatically calculates its R-squared value. Trendline reliability A trendline is most reliable when its R-squared value is at or near 1. The type of data you have determines the type of trendline you should use. When you want to add a trendline to a chart in Microsoft Graph, you can choose any of the six different trend/regression types. Returns or sets the period for the moving-average trendline.Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 MS Graph 2007 More. Returns the parent object for the specified object. Returns or sets the trendline order (an integer greater than 1) when the trendline type is xlPolynomial. True if Microsoft Excel automatically determines the name of the trendline. True if the point where the trendline crosses the value axis is automatically determined by the regression. Returns or sets the point where the trendline crosses the value axis. Returns the index number of the object within the collection of similar objects. Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Setting this property to True automatically turns on data labels.
True if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). True if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Returns a DataLabel object that represents the data label associated with the point or trendline. Returns a 32-bit integer that indicates the application in which this object was created. Returns a Border object that represents the border of the object.
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Returns an Application object that represents the Microsoft Excel application. 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. Use Trendlines( index), where index is the trendline index number, to return a single Trendline object. The Trendlines collection contains all the Trendline objects for a single series. The Trendline object is a member of the Trendlines collection. GuidAttribute InterfaceTypeAttribute Remarks