![insert trendline equation excel insert trendline equation excel](https://cdn.ablebits.com/_img-blog/trendline/delete-trendline-excel.png)
Let us first see how to format general settings for the trendline: You can add additional information on your trendline (like an equation, R2 value, etc.).You can change the type of trendline (eg: linear, polynomial, moving average, etc.).You can add different effects (like drop shadow, glow, etc.).You can set different types of caps on either end of the trendline (like arrows, squares, etc.).You can change the color, width, and style of your trendline.Also read: How to Add Secondary Axis in Excel Charts? How to Format the TrendlineĮxcel provides a number of options to customize trendlines in charts. We will see how to do that in the next section. However, you can further customize this line according to your requirement.
![insert trendline equation excel insert trendline equation excel](https://www.online-tech-tips.com/wp-content/uploads/2020/11/linear-regression-trendline-7.png)
![insert trendline equation excel insert trendline equation excel](https://i.ytimg.com/vi/TyqnF1750og/maxresdefault.jpg)
Note that the trendline is shown here as a simple dotted line by default. This means that as the value of x increases, the value of y increases too. Looking at the above chart, the trendline shows that the two variables have a positive relationship since the trendline shows the movement of the points in the positive direction.