This example teaches you how to add a trendline to a chart in Excel.

1. Right click the data series, and then click Add Trendline...

Add Trendline

2. Choose a Trend/Regression type. Click Linear.

3. Specify the number of periods to include in the forecast. Type 3 in the Forward box.

4. Check "Display Equation on chart" and "Display R-squared value on chart".

Format Trendline

5. Click Close.


Trendline in Excel

Explanation: Excel uses the method of least squares to find a line that best fits the points. The R-squared value equals 0.9295, which is a good fit. The closer to 1, the better the line fits the data. The trendline gives you an idea which direction the sales are going. In period 13, you might be able to achieve a sales of almost 120. You can verify this by using the equation. y = 7.7515 * 13 + 18.267 = 119.0365.

49 chapters, 300 examples,Our website is 100% free.

If you like our website, please link to this page from your blog / website or share this page on Google+

11/18 Completed! Learn more about charts >
Go to Top: Trendline    |    Go to Next Chapter: Pivot Tables