You can add a trendline to a chart series. You can use the trendline formula
(be sure to use enough significant figures to get a reasonable result) or
the LINEST worksheet function to get coefficients to compute Y values for
known X values.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"Flyrodder" wrote in message
...
I create a chart from data. I now want to use that chart and data to
predict
the y value for any given value of x. How do I go about doing that in
Excel?
Is there a way to do curve fitting to get an equation for a curve? HOw do
I
go about doing any and/or all of this?