+ Reply to Thread
Results 1 to 6 of 6

Need help extrapolating data and then adding it to a graph

  1. 02-18-2018, 02:50 PM #1
    THANKSFORTHEHELP
    THANKSFORTHEHELP is offline
    Registered User
    Join Date
    02-18-2018
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    2

    Need help extrapolating data and then adding it to a graph

    Basically based on the values I already have in both the A and B columns I need to extrapolate values for the unknown cells(I have also included the file to make any mistakes I may have made more easily visible), I am not sure how to actually do this on excel,I have tried the forecast formulas both they are all either ineffective or I have an error I cannot fix. Any help provided would be greatly appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-18-2018, 04:52 PM #2
    PietBom
    PietBom is offline
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Need help extrapolating data and then adding it to a graph

    I did 2 interpolations and 1 extrapolation (3 different formulas)
    Is this what you expected ?
    Attached Files Attached Files
    Kind regards,
    Piet Bom
    Reply With QuoteRegister To Reply
  3. 02-18-2018, 05:09 PM #3
    mjr veverka
    mjr veverka is offline
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Need help extrapolating data and then adding it to a graph

    The results of the 'Forecast' function.
    I don't understand what's wrong with this function ?
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  4. 02-18-2018, 05:25 PM #4
    PietBom
    PietBom is offline
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Need help extrapolating data and then adding it to a graph

    @porucha,
    Forecast function is much better, you are right.
    Reply With QuoteRegister To Reply
  5. 02-18-2018, 07:59 PM #5
    THANKSFORTHEHELP
    THANKSFORTHEHELP is offline
    Registered User
    Join Date
    02-18-2018
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    2

    Re: Need help extrapolating data and then adding it to a graph

    Thanks for the help I failed to include the dollar sign.
    Reply With QuoteRegister To Reply
  6. 02-19-2018, 02:28 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Need help extrapolating data and then adding it to a graph

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extrapolating Missing Data
    By GregOMH in forum Excel General
    Replies: 2
    Last Post: 05-13-2016, 11:20 PM
  2. Extrapolating data
    By sherlock1241 in forum Excel General
    Replies: 3
    Last Post: 04-21-2015, 12:03 PM
  3. Extrapolating data within a table
    By MacroIdiot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2011, 12:20 PM
  4. Extrapolating spreadsheet data
    By djohnalyn in forum Excel General
    Replies: 4
    Last Post: 07-06-2011, 05:58 PM
  5. Extrapolating Data from 1 Period to Another?
    By stviking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-07-2008, 08:49 AM
  6. extrapolating a graph
    By Peter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-29-2006, 06:25 PM
  7. [SOLVED] extrapolating data from chart
    By [email protected] in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2006, 06:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1