time and date to 3d graph

[WilcoNI]

Dear,

I'm trying to create a 3D graph from a excel sheet which contains date/dime, wavelenghts and spectral data. The graph is now created but i can't get the date/time into the graph. Converting the string to number isn't working because it can't format the number into date and time. The array size is now used where the date/time should be.

Does anyone has a solution for this?

Using Labview 2009 with SP1.

Thank you. Best regards,

Wilco

P.S. please change fp excel file path before running the program.

[GerdW]

Hi Wilco,

don't know where you want to put those timestamps into the graph, but finished the conversion for you...

Why do you call this an "Excel" file when it is a simple tsv-file with a wrong extension?

[GerdW]

Hi Wilco,

now plotting the timestamps as X axis values. I doubt you like this...

[WilcoNI]

Hello GerdW,

Thank for you effort and quick reply!

I did not know it was a .csv file. It came out of an other program as a .fp file but NI does not accept uploading a .fp file so i changed it to .xls.

Yes the timestamps please as X axis value. I see you are also struggeling..... The timestamp to double value wasn't quite what i had in mint

Regards,

Wilco

[GerdW]

Hi WIlco,

as said before: I doubt you like it

I didn't find a way to set the format of the x axis (haven't worked so much with 3d graphs). Maybe Ben can take over this topic?

[Ben]

I only have tow changes to recomend

Sutract the first time stamp from all to just look at the time of the test...

Divide by 60 to plot in minutes.

Ben