Trend Line is a line indicating the general course or tendency of points on your chart.
- Regression Type
Choose the representation type of the trend line:
A linear trendline is a best-fit straight line that is used with simple linear data sets.
A power trendline is a curved line that is best used with data sets that compare measurements that increase at a specific rate.
An exponential trendline is a curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trendline if your data contains zero or negative values.
A 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. A logarithmic trendline can use negative and/or positive values.
- Trend Line style
Choose solid/ dashed/ dotted style of the trend line.
Define the color of the trend line.
Set opacity of your trend line.
Define trend line thickness.
- Regression Equation
Enable regression equation to show it on the trend line.
- Equation Position
Choose Left/ Center/ Right position for the equation on the trend line and
Top/ Middle/ Bottom for vertical position of the shown equation.
- Equation Style
Define the font size and opacity of the shown equation.
- Show R2
Show the R-squared value.