How to Extend Trendline in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

In a chart, a Trendline additionally referred to as a line of the first-class suit, is an immediate or curved line that depicts the overall sample or fashionable course of the information. This analytical method is maximum often used to illustrate information adjustments over the years or the connection among variables. A trendline resembles a line chart visually, however, it would not hyperlink the real information factors in the manner a line chart does. A first-class-suit line presents the general sample in all of the information at the same time as heading off statistical flaws and insignificant outliers. It can every now and then be used to expect trends. In this article, we will show you how to extend Trendline in Excel.


Step-by-Step Procedures to Extend Trendline in Excel

A useful technique for forecasting future data values is using a trend line. To extend a Trendline, we will edit Forecast Box in Excel creating Trendline first. Let’s say we have a sample data set to extend the trendline in Excel using step by step procedure. The following steps are given below.

Sample Data


Step 1: Selecting Data Set

  • Firstly, select the C and D columns from the given data set.

Sample Data


Step 2: Using Charts Group

  • Now, select the Insert.
  • Then, select the Insert Scatter Chart command from the Charts.

Sample Data

Step by Step Procedures to Extend Trendline in Excel


Step 3: Creating Trendline in Excel

  • Now, select the Trendline option from the Chart Elements.

Step by Step Procedures to Extend Trendline in Excel

Read More: How to Add Trendline Equation in Excel


Step 4: Editing Forecast Box to Extend Trendline in Excel

  • This is the initial trendline chart with the given data set.

Step by Step Procedures to Extend Trendline in Excel

  • Firstly, Double-click on the trendline to open the Format Trendline Panel.
  • Besides, the two red circles represent the two initial values of the trendline chart.
  • Finally, you will see that the Forward and Backward values are zero under the Forecast Box.

Step by Step Procedures to Extend Trendline in Excel

  • Now, to extend the trendline, type your desired value in the Forward Box.
  • Secondly, we will use 9 for extending the trendline, and you will see the following red circle showing the extending point.

Step by Step Procedures to Extend Trendline in Excel

  • Now to decrease the trendline, type your desired value in the Backward Box.
  • Then, we will use 9 to decrease the trendline, and you will see the following red circle showing the decreasing point.

Step by Step Procedures to Extend Trendline in Excel

Read More: How to Add a Trendline to a Stacked Bar Chart in Excel


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


Conclusion

In this article, I’ve covered the step-by-step process of how to extend Trendline in Excel. I sincerely hope you enjoyed and learned a lot from this article. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.



<< Go Back To Trendline in Excel | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo