Skip to main content
JB_102207698-Gravel
8-Gravel
Aug 19, 2022 9:43 PM UTC
Question

Trace Curve from plot

How to trace the curve on plot. I would like to generate the plot from data which is in my excel sheet 

4 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
Aug 19, 2022 10:12 PM UTC

You may use interpolation (the simplest is linear interpolation, more elaborate the three flavors of cubic splines) or you may use approximation (Mathcad offers a number of different fit functions and also a generic "genfit"). If you do not want to use the built-in fitting functions you may also use a solveblock with minerr.

Translate
JB_102207698-GravelAuthor
8-Gravel
Aug 19, 2022 11:08 PM UTC

And how to import points (x, y and z) from an external file excel file to plot ? I have been trying but cold not find a easy method 

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Aug 20, 2022 1:06 AM UTC

You can insert an Excel component in your sheet, but personally I find it more convenient and straightforeward to use the READEXCEL function.

BTW, as far as i know all built-in curve fit function would just deal with 2D data. For 3D data you would have to resort to a solve block as already mentioned, I guess.

Translate
terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Aug 20, 2022 5:38 AM UTC

Hi,

If it is not confidential perhaps you can upload the excel file together with any Prime files you have attempted?

This way better answer with example can be given.

Translate
Terms & ConditionsAccessibility statement