Skip to main content
8-Gravel
August 19, 2022
Question

Trace Curve from plot

  • August 19, 2022
  • 2 replies
  • 1666 views

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

2 replies

25-Diamond I
August 19, 2022

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.

8-Gravel
August 19, 2022

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 

25-Diamond I
August 20, 2022

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.

21-Topaz II
August 20, 2022

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.