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.
