1 Use LINEST to find the equation of the line (I am assuming polynomial) -
see my website fro details
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
2 Differentiate the line of best fit to find the slope (m) at point x; this
is also the slope of the tangent
3 Use y=mx + b for 2 x-points on each side of the know x to find two x,y
pairs
4 Make a line with these two points (use copy followed by Paste Special; New
series)
best of luck with the homework
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"elams" wrote in message
oups.com...
i have derived graph in microsoft excel sheet.i want to draw the
tangent line for that graph.but i do not know equation for the graph.
in x and y axis i have some values.i want particular point of xaxis to
draw the tangent line for the graph that would be meet the particular
point of the curve from that point i want to find out corresponding y
value for the graph. please any body know about tangent line for graph
help me.