View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Tmblweed
 
Posts: n/a
Default Scatterplot Question


Thank you for your reply.

While I understand that this allows you to "read off" the value of the
point, is there any way to ask Excel to compute that value? Also, while the
website may help when the point plotted is in the same worksheet as the
graph, I don't quite know how to drag the point to the graph, if the graph is
on a separate worksheet.

"Bernard Liengme" wrote:

Visit http://www.tushar-mehta.com/excel/ti...lue/index.html
Please come back if you have more questions
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tmblweed" wrote in message
...
I have a few points, graphed as a scatterplot and the points are connected
by
a smooth line. (For example: (0,0), (5, 6), (6, 8), (10, 20).)

Since the points are connected by 3 different smooth lines, each line has
a
different slope/degree. Is there any way to have Excel determine the
y-value
of a point that is not a plotted point (anything besides x = 0, 5, 6, 10)?
For example, based on the smooth line, can I ask Excel to find the y-value
of
x=1 or x=9?

Thank you very much for your help!