Trendlines in Excel are used to identify the underlying trends in data. Select Display Equation on Chart to show the equation on the chart.Select a trendline type from the drop-down menu.Select the data series and then click the Trendline button.
Click the Insert tab and then click Scatter or Line.