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 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 are expecting trends. In this article, we will show you how to extend Trendline in Excel.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice yourself.
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.
Step 1: Selecting Data Set
- Firstly, select the C and D columns from the given data set.
Read More: How to Calculate Trend Analysis in Excel (3 Easy Methods)
Step 2: Using Charts Group
- Now, select the Insert.
- And then, select the Insert Scatter Chart command from the Charts.
- Now, click on the Scatter Chart option to create a scatter chart first.
Read More: How to Calculate Trend Percentage in Excel (With Easy Steps)
- How to Find Slope of Polynomial Trendline in Excel (with Detailed Steps)
- Add Multiple Trendlines in Excel (With Quick Steps)
- How to Make a Polynomial Trendline in Excel (2 Easy Ways)
Step 3: Creating Trendline in Excel
- Now, select the Trendline option from the Chart Elements.
Read More: How to Create Monthly Trend Chart in Excel (4 Easy Ways)
Step 4: Editing Forecast Box to Extend Trendline in Excel
- And this is the initial trendline chart with the given data set.
- 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.
- 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.
- Now to decrease the trendline, type your desired value in the Backward Box.
- Then, we will use 9 for decreasing the trendline, and you will see the following red circle showing the decreasing point.
Read More: How to Add a Trendline to a Stacked Bar Chart in Excel (2 Ways)
In this article, I’ve covered step by step process of how to Extend Trendline in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.