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
quot;ralphquot; gt; wrote in message
...
gt; In an xy scatter plot one can choose the type of line connecting the data
gt; points (smooth, straight, etc.). Once this is done, Is there a simple way
gt; of
gt; determining the y value of graph for a specific x value without doing
gt; successive approximations with 0 shifts. I'd rather not purchase a
gt; graphing
gt; program just for this simple task.
Hi ralph,
There is a sample called 'Intercept Vertical Lines' at
www.edferrero.com/charting.aspx that may do what you want.
Ed Ferrero
Microsoft Excel MVP
www.edferrero.com
gt; In an xy scatter plot one can choose the type of line connecting the data
gt; points (smooth, straight, etc.). Once this is done, Is there a simple way
gt; of
gt; determining the y value of graph for a specific x value without doing
gt; successive approximations with 0 shifts. I'd rather not purchase a
gt; graphing
gt; program just for this simple task.
- Jul 20 Thu 2006 20:08
y value vs x
close
全站熱搜
留言列表
發表留言