+ Reply to Thread
Results 1 to 4 of 4

Extending Trendline by Small Values

  1. #1
    Registered User
    Join Date
    09-21-2013
    Location
    The Cretaceous Period
    MS-Off Ver
    Excel for Mac 2011
    Posts
    3

    Extending Trendline by Small Values

    I am trying to extend a linear trendline for a graph of molarity vs absorbance. Unfortunately, excel will only let me extend the trendline by 0.5 forward or backward, and the values that I am working with are much smaller. The units that I am working with are 0.001, and extending the trendline by 0.5 zooms out from my values so far that they cannot be seen. Is there any way that I can extend the trendline by smaller values than 0.5? Thanks for the help.

  2. #2
    Registered User
    Join Date
    09-21-2013
    Location
    The Cretaceous Period
    MS-Off Ver
    Excel for Mac 2011
    Posts
    3

    Re: Extending Trendline by Small Values

    Bump. I could really use some help with this...

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,750

    Re: Extending Trendline by Small Values

    Can I assume you are using the chart trendline feature to generate the trendline? I find that I never use the chart trendline feature. Instead, I prefer to generate regressions using the LINEST() function http://office.microsoft.com/en-us/ex...005209155.aspx

    Along the same lines, you can also use the TREND() function http://office.microsoft.com/en-us/ma...081.aspx?CTT=1

    If you are intimidated by these worksheet functions, the easiest approach might be to display the equation on the chart (be sure to use enough decimal places), hand enter the coefficients of the equation in the spreadsheet, then calculate the extension in the spreadsheet.

    However you do it, you can show the extension on the chart by plotting the trendline as calculated in the spreadsheet. Then you will have the flexibility you need to extend the trendline in whatever increment you want to use.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    09-21-2013
    Location
    The Cretaceous Period
    MS-Off Ver
    Excel for Mac 2011
    Posts
    3

    Re: Extending Trendline by Small Values

    I think I can work with the calculating the extension idea. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-22-2012, 11:19 PM
  2. extending or populating values automatically
    By kornfind in forum Excel General
    Replies: 9
    Last Post: 09-21-2011, 10:47 PM
  3. Extending VLOOKUP to sum all the matching values
    By blackflame in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2010, 06:08 AM
  4. Trendline Values
    By methexis in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-28-2007, 01:00 PM
  5. [SOLVED] Extending a trendline to the y axis
    By becca26387 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-07-2005, 11:30 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1