View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I determine a y value for x ?

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?