There is no magic single function in Excel to do this. Essentially you have to calculate the the XY coordinates of the tangent line and plot them on the graph.
Here is an excellent site that describes one way to do it and it has an Excel template to help you.
Answers & Comments
Verified answer
There is no magic single function in Excel to do this. Essentially you have to calculate the the XY coordinates of the tangent line and plot them on the graph.
Here is an excellent site that describes one way to do it and it has an Excel template to help you.
http://www.joma.org/images/upload_library/4/vol7/M...