How do you pull an equation off of a scatterplot with smooth lines in Excel?

Zach Hill 1 Reputation point
2022-02-02T05:40:41.883+00:00

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!

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,032 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,561 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Herbert Seidenberg 1,191 Reputation points
    2022-02-02T20:00:56.757+00:00

    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