Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
How to trace the curve on plot. I would like to generate the plot from data which is in my excel sheet
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.
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
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.
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.