+ Reply to Thread
Results 1 to 6 of 6

Graphing question

  1. #1
    Registered User
    Join Date
    03-04-2009
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    9

    Graphing question

    Hello,

    How do I extrapolate a graph which do not have a formula for the graph?
    At the end of the graph, I found that I don't have enough data and would want to have a longer graph?

    I posted this question to another two forums
    http://en.kioskea.net/forum/affich-74796-excel-charting
    http://www.mrexcel.com/forum/showthr...91#post1861791
    Last edited by wenlianglo; 03-05-2009 at 06:23 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Graphing question

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-04-2009
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Graphing question

    Sorry about cross posting.
    So, is FORECAST also your solution?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Graphing question

    Did you try Andrew's solution?

  5. #5
    Registered User
    Join Date
    03-04-2009
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Graphing question

    Yes, I am playing with FORECAST function now. The graph looks somehow weird, so I was wondering is there other ways.

  6. #6
    Registered User
    Join Date
    03-04-2009
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Graphing question

    Forecast is a linear function, so my scattered graph will have straight lines at forecasted zone.
    Any suggestion?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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