How To Extend The Trend Line In Excel - Techwalla

Get the latest news and alerts! Later Notify

1. Tech Support
2. How To

How to Extend the Trend Line in Excel By Fatima Farakh Fact Checked Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here. Use Excel's forecasting feature to extend a trend line.

Data forecasting with a trend line is a practical method for determining future data values. Microsoft Excel 2010 lets you add a trend line to a chart in a spreadsheet to represent your data's current and future trends. Excel draws the two ends of the trend line based on your existing data values. You can access the trend line options in Excel to extend the line beyond the initial points to forecast future values of your data.

Advertisement

Step 1

Open Microsoft Excel 2010.

Video of the Day

Step 2

Click the "File" tab and select "Open." Select your file and click the "Open" button.

Step 3

Right-click the trend line in your spreadsheet file and select "Format Trendline" from the menu.

Advertisement

We Recommend

Tech Support How to Draw a Tangential Line in Excel By James T Wood Tech Support How to Graph Linear Equations Using Excel By Stephanie Ellen Tech Support How to Make Column A the X-Axis in Microsoft Excel By James Green

We Recommend

Tech Support How to Draw a Tangential Line in Excel By James T Wood Tech Support How to Graph Linear Equations Using Excel By Stephanie Ellen Tech Support How to Make Column A the X-Axis in Microsoft Excel By James Green

Step 4

Locate the "Forecast" section under the "Trendline Options." Type a value in the "Forward" field to extend the trend line forward, and type a value in the "Backward" field to extend it backward.

Advertisement

Step 5

Click the "Close" button.

Video of the Day

Advertisement

Advertisement

references & resources

• Microsoft Office: Add, Change, or Remove a Trendline in a Chart
• Microsoft Office: Excel 2010 Help and How-to

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

People are Reading

1

How to Make Functional Dependencies in Visio

2

How to Insert Minor & Major Grid Lines in Excel

3

How to Convert CSV to TSV

You May Also Like

1

How to Graph a CSV File in Excel

2

How to Add a Line to an Excel Stacked Chart

3

How to Make Lines on an Excel Spreadsheet