• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Extend the Trend Line in Excel

How to Extend the Trend Line in Excel

By: Fatima Farakh
  • Share
  • Share on Facebook

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.

...
Use Excel's forecasting feature to extend a trend line.

Step

Open Microsoft Excel 2010.

Step

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

Step

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

Video of the Day

Step

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.

Step

Click the "Close" button.

Show Comments

Related Articles

How to Graph Linear Equations Using Excel

How to Graph Linear Equations Using Excel

Around The Home
Productivity
By: Stephanie Ellen
How to Make Column A the X-Axis in Microsoft Excel

How to Make Column A the X-Axis in Microsoft Excel

Around The Home
Productivity
By: James Green
How to Add a Line to an Excel Stacked Chart

How to Add a Line to an Excel Stacked Chart

Around The Home
Productivity
By: Anna Rose
How to Draw a Tangential Line in Excel

How to Draw a Tangential Line in Excel

Around The Home
Productivity
By: James T Wood
How to Create a Curved Line Graph in Excel or Word

How to Create a Curved Line Graph in Excel or Word

Around The Home
Productivity
By: Erika Dean
How to Build a Pyramid Graph in Excel

How to Build a Pyramid Graph in Excel

Around The Home
Productivity
By: Cooper Temple
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.