If you've got a curved line, such as a quadratic rather than your linear
expression, then you'd need to include more than two points. Instead of
just using X values of 0 and 4000, you could interpolate and have values 0,
200, 400, etc. for example. Then use your expression for Y as a function of
X to let Excel calculate the Y values in the second column, and plot the
graph as you've just done. You can either let Excel join the points with
short straight lines like the one line you've just drawn between your two
points, or (if the curve is reasonably well-behaved) you can let Excel put
in a curve through the points. [You've seen the different sub-types within
the XY chart option.]
--
David Biddulph

"BigDaddyCool" wrote in message
...
Yay! You rock! Thank you!

I guess this little trick couldn't work with any curved graphs, though
(because all we're doing is connectiong two already calculated endpoints
with
a line). I mean, there isn't any real "computing" going on, is there? :(

BigDaddyCool

"Del Cotter" wrote:


"BigDaddyCool" wrote
I did that, and the problem is it just interprets it as two more
plot points rather than the endpoints of a continuous line graph.

Go to Format.. Selected Data Series.. and click the radio button in the
Patterns:Line dialogue from "None" to "Automatic" or "Custom". If you
want, you can also switch off the points by clicking the Marker radio
button from "Automatic" to "None".

Now you have a line and points, or a line and no points.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.