+ Reply to Thread
Results 1 to 2 of 2

how do i find values on a line graph in Excel?

  1. #1
    sorrelponie
    Guest

    how do i find values on a line graph in Excel?

    i made a plot graph connected by a line. now i need to find values on that
    line. how? thanks.

  2. #2
    Gary''s Student
    Guest

    RE: how do i find values on a line graph in Excel?

    Two possible ways:
    1. if you have the formula for the line, use it go calculate the reading.

    2. If you have sample points on the line, but no formula, then you can use
    the FORECAST() function. If you have two points [x1,y1] and [x2,y2] and you
    also have a third x3, then FORECAST() will calculate y3 for you. The neat
    thing about FORECAST() is that it works equally well if x3 is between x1 and
    x2 or is outside of the range.
    --
    Gary''s Student


    "sorrelponie" wrote:

    > i made a plot graph connected by a line. now i need to find values on that
    > line. how? thanks.


+ 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