Choosing the best trendline for your data

Microsoft Graph

Show All

Choosing the best trendline for your data

When you want to add a trendline to a chart in Microsoft Graph, you can choose any of the six different trend/regression types. The type of data you have determines the type of trendline you should use.

Trendline reliability   A trendline is most reliable when its R-squared value is at or near 1. When you fit a trendline to your data, Graph automatically calculates its R-squared value. If you want, you can display this value on your chart.

Linear

Logarithmic

Polynomial

Power

Exponential

Moving average