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.

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ralph" wrote in message
...
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.

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

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.