y value vs x

[Guest]

In an xy scatter plot one can choose the type of line connecting the data
points (smooth, straight, etc.). Once this is done, Is there a simple way of
determining the y value of graph for a specific x value without doing
successive approximations with 0 shifts. I'd rather not purchase a graphing
program just for this simple task.

 

[Bernard Liengme]

You could find an equation that fits the data (see trendline)
best wishes

 

[Ed Ferrero]

Hi ralph,

There is a sample called 'Intercept Vertical Lines' at
http://www.edferrero.com/charting.aspx that may do what you want.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com