Scatter Chart

[Guest]

How to get Y-axis value from scatter chart if we know X value

 

[Jon Peltier]

If your X values are in A2:A10 and your Y values are in B2:B10, and if
your known X value is in C1, this formula will provide the Y value along
the least squares fitted line:

=INTERCEPT(B2:B10,A2:A10)+SLOPE(B2:B10,A2:A10)*C1

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

 

[Tushar Mehta]

In addition to Jon's suggestion, you might also want to look at
Read Chart Value
http://www.tushar-mehta.com/excel/tips/read_chart_value/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions