You can approximate a curve by stringing together a lot of short segments.
In other words, instead of two endpoints based on two X values and the
coefficients, use enough X values so that the curve looks smooth, and
calculate the Y values in the next column in the same way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"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.