title: How to draw a line parallel to the linear portion of the curve in excel?
body: <p>I have stress strain data from tensile test. I have drawn a stress vs strain graph in excel.I need to find the yield point.For that, I need to draw a line parallel to the linear(straight) portion of the curve with 0.2% offset in x axis and see where it intersects with the original curve.</p>
  
  <p>So, I tried to keep only the linear portion data and drew a trendline, which gives me straight line equation y=mx. Now, if I want 0.2% offset, equation of line is y=mx +c.
  I have the equation, how to draw this line in excel with the equation? And how to get the intersection point? Is my approach right? Please help.</p>