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

1. ## 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. ## 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.

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

#### 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