Curve through X & Y value in excel

[rocket100]

Hi Guys,

I have a x and y value in excel sheet and I would like to make a curve from the date. Please suggest any advise.

Thank you

regards

Rodney

 

[kapmnit123]

Hi Rodney,
What NX version you are on?
Best Regards
Kapil Sharma

 

[rocket100]

NX 8.5.
Thanks

 

[kapmnit123]

Hi Rodney,
In that case first of all you can save the excel sheet in a tab delimited format (for example i saved it in .txt format).
Now go to file/Import/Points from file and import these points (it will create a seperate Group consisting of all these points) and the use INSERT/CURVE/FIT CURVE/FIT SPLINE and select the Group to craete a spline.
Bestr Regards
Kapil

 

[kapmnit123]

That being said ....if you wish to drive the curve and points associatively (automatic update of spline everytime you change the values of co-ordinates or change the number of points)referring to the external excel sheet then i couldn't think of an OOTB but surely we do have VB programs (you can refer to some old posts in the forum as lot of expert comments have been given on the same ) for that or may be Knowledge Fusion (i have written one myself some years back but it is in NX7.5.).
Thanks and Best Regards
Kapil

 

[rocket100]

Thank you Kapil, It worked great.

regards

Rodney