How to put a trend line
Add a trendline You can add trendlines to see patterns in your charts. Before you create a trendline: You can add trendlines to bar, line, column, or scatter charts. On your computer, open a spreadsheet in Google Sheets. Double-click a chart.
Add Trend Lines to a Visualization
At the right, click Customize Series. Optional: Next to "Apply to," choose the data series you want to add the trendline to. Click Trendline. Under "Trendline," you can edit: Trendline types.
How To Draw Trendlines Like A Pro (My Secret Technique) by Rayner Teo
Line color, opacity, or thickness. R squared. This shows how closely the trendline fits the data. This is only available if you add a legend.
How to add trendline in Excel chart
Polynomial degrees. This is only available for polynomial trendlines. Average types. This is only available for moving average trendlines.
Linear: For data that closely follows a straight line. Exponential: For data that rises and falls proportional to its current value. Polynomial: For data that varies.
Logarithmic: For data that rises or falls at a fast rate and then flattens out. Power series: For data that rises or falls proportional to its current value at the same rate.
Moving average: Helps smooth out data that is unstable or more variable. How can we improve it?