Thread: y value vs x

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" <ralph@discussions.microsoft.com> wrote in message
news:284B39DE-20C6-40CB-AB60-39B5AE8E3A7C@microsoft.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.

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.