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.