Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Draw a Tangent in Microsoft Excel graph

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-01-2012
Member
 
Join Date: Jan 2012
Posts: 17
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.

Reply With Quote
  #2  
Old 13-01-2012
Member
 
Join Date: Jul 2011
Posts: 419
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.
Reply With Quote
  #3  
Old 13-01-2012
Member
 
Join Date: Jul 2011
Posts: 429
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.
Reply With Quote
  #4  
Old 13-01-2012
Member
 
Join Date: Aug 2011
Posts: 454
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.
Reply With Quote
  #5  
Old 13-01-2012
Member
 
Join Date: Aug 2011
Posts: 557
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 25-02-2012 10:47 AM
Want help to draw a circle in a graph via point data and axis in Excel DEvOTeEL MS Office Support 1 25-02-2012 10:31 AM
How to get Line Curve formula without a graph in Microsoft Excel vALaNCiA MS Office Support 8 07-02-2012 06:59 PM
How can I add a new line in Excel 2007 Graph ashwin2012 MS Office Support 2 03-02-2012 05:02 PM
How to draw a graph of the cost baseline? hindustnidude Microsoft Project 3 27-05-2008 01:07 AM


All times are GMT +5.5. The time now is 08:22 PM.