Home Â» How to Find the Slope of a Trendline in Excel

# How to Find the Slope of a Trendline in Excel

Often you may want to find the slope of a trendline in Excel.

Fortunately this is fairly easy to do and the following step-by-step example shows how to do so.

### Step 1: Create the Data

First, letâ€™s create a fake dataset to work with:

### Step 2: Create a Scatterplot

Next, letâ€™s create a scatterplot to visualize the data.

To do so, highlight the data:

Then click the Insert tab along the top ribbon and click the first option within the Insert Scatter (X, Y) option in the Charts group. This will produce the following scatterplot:

### Step 3: Add a Trendline

Next, letâ€™s add a trendline to the scatterplot.

To do so, click anywhere on the scatterplot. Then click the green plus (+) sign in the top right corner of the chart and click the box next to Trendline:

### Step 4: Display the Slope of the Trendline

To find the slope of the trendline, click the right arrow next toÂ Trendline and clickÂ More Options:

In the window that appears on the right side of the screen, check the box next to Display Equation on chart:

The trendline equation will automatically appear on the scatterplot:

The trendline equation turns out to be y = 2.4585x â€“ 1.3553.

This means the intercept is -1.3553 and the slope is 2.4585.Â