Thirdly, from Recommended Charts, choose a proper Scatter Chart.For that we will gonna use the dataset described above and follow the steps below: In this case, our goal is to find the slope of the trendline in Excel by using the trendline option. We will use this dataset for our desired two methods as described below.ġ.
For instance, we have an independent variable in Column C marked as X and a dependent variable in Column B marked as Y. To understand easily, we’ll use a sample dataset as an example in Excel. 2 Easy Methods to Find Slope of Trendline in Excel
