Click “Trendline” from the “Analysis” group.Select the chart and then click the “Layout” tab at the top of the spreadsheet.Open your Excel spreadsheet with the chart.
The equation of the trendline and slope will be displayed on the chart. In the Format Trendline dialog box, select “Options”, enter the “Order” of the equation, and select “Display Equation on Chart”.
Then, right-click on the trendline and select “Format Trendline”. Finding the Slope of a Trendline in Excel: To find the slope of a trendline in Excel, start by adding a trendline to your graph.
