Trendline equation is a formula that finds a line that best fits the data points.Additionally, Microsoft Excel allows displaying a trendline equation and R-squared value in a chart: When adding a trendline in Excel, you have 6 different options to choose from. Excel trendline equation is wrong – reasons and fixes.It is very easy to add a trendline in Excel.