

 Thread Tools  Search this Thread 
#1
 
 
Draw a Tangent in Microsoft Excel graph
I need help to get a tangent line in Microsoft Excel. There is no option given in the settings of graph in excel. Is there any other way to do that. 
#2
 
 
Re: Draw a Tangent in Microsoft Excel graph
There is no built in functionality for this. You could use the (AutoShape) drawing tool and draw a line, but that's not very satisfying. Or you could determine the slope at the desired point, compute the endpoints of the line with the calculated slope intersecting at the desired point, and add ax XY series to the chart using these endpoints. 
#3
 
 
Re: Draw a Tangent in Microsoft Excel graph
I am assuming that you need this result for the school. Then I would not make such a great idea and spend hours with Excel. I would print out the chart, read off as large as possible, i.e. on an A4 sheet of paper and then manually create a tangent and its slope from the intersections with the axes. Is fast and sufficiently accurate. If you really want to try it in Excel: I know of no way to provide only a portion of the graph with a trend line. As a remedy, I would then only a diagram of the relevant part (i.e., the linear increase) and let them draw then create a linear trend line. 
#4
 
 
Re: Draw a Tangent in Microsoft Excel graph
The function describes a saturation kinetics. The formula is known. Can you adjust the parameters of the formula with the method of least squares sum leave (goes through the Solver in Excel). Based on the formula and the fitted parameter, you can easily calculate the initial slope. Then a pair of points is sufficient to draw the line through the origin of Excel with this slope can be. This is not just then some approximate arbitrary line that arbitrarily on any of lying on a straight points under consideration is based, but the best line that uses all available data and is based on the model of saturation kinetics. 
#5
 
 
Re: Draw a Tangent in Microsoft Excel graph
The tangent to a curve is usually an equation of a line, so Excel to calculate the coefficients and variables needed to calculate this line. It is obvious that this is not simple, you need the formulas to calculate the coordinates of the point of tangency is a point on the line, must be points of intersections with X and Y. This will make three points is already one too many for a right. 

Tags: excel tan, microsoft excel, microsoft office, office application, spreadsheet 
Thread Tools  Search this Thread 

Similar Threads for: "Draw a Tangent in Microsoft Excel graph"  
Thread  Thread Starter  Forum  Replies  Last Post 
Y axis label cutoff in Excel graph  Hache hi  MS Office Support  2  25022012 10:47 AM 
Want help to draw a circle in a graph via point data and axis in Excel  DEvOTeEL  MS Office Support  1  25022012 10:31 AM 
How to get Line Curve formula without a graph in Microsoft Excel  vALaNCiA  MS Office Support  8  07022012 06:59 PM 
How can I add a new line in Excel 2007 Graph  ashwin2012  MS Office Support  2  03022012 05:02 PM 
How to draw a graph of the cost baseline?  hindustnidude  Microsoft Project  3  27052008 01:07 AM 