This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 80%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZH%3C/text%3E%3C/svg%3E)
I need the equation of a "smooth line" in a scatterplot that looks almost logarithmic. I need the equation so that I can determine the intercept of another line crossing it, without approximating. It's a stress-strain curve for anyone who knows what that is.
The trendlines I'm offered (no matter which type or order/period of the function) are nowhere close to fitting the actual curve. The logarithmic trendline returns an error and won't display itself (possibly because the curve dives down and away from its asymptote).
I played around with making my own functions and plugging the variables into the built-in Excel Solver which gave me the same results as the shoddy trendlines.
I'm now wondering how Excel knows how to plot the smooth line through these data points. Is there a way to get the equations of these splines (or whatever they may be) off of the graph? Before you answer, I know about the decimal place workaround thing for trendlines; I'm out to 30 decimal points.
Please help!
Hi,
Please check if this link's relpy of shg is helpful:
https://www.ozgrid.com/forum/index.php?thread/71520-equation-of-a-smooth-xy-scatter-chart/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Excel 365
Fit a curve to some stress-strain test points.
External math program and degree desirable.
https://www.mediafire.com/file/99l1nvqfjlw0g8c/02_02_22.xlsx/file
https://www.mediafire.com/file/2k5fmoxam5bhgjs/02_02_22.pdf/file
Interesting, I got as far as mixing logs and polynomials with a sinusoid, but I never considered using separate equations for certain regions.
How do you know when to stop using one equation and switch to another?
Find the intersection of the 3 calculated curves,
either by inspection or calculations.
https://www.mediafire.com/file/cum1y5hij3k5kqn/02_02_22a.pdf/file