close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()