displaying time on exported graph in excel

[wond3rboy]

Hi, i am making a making a vi for a structural health monitoring system. I am exporting the resulting vi in the form of a report in excel and want to display the time(which i have got for the xaxis in the temperature graph) on the exported graph as well. Is there a way one can do it? i am using LabVIEW 2009.

[Carlos_O]

Hi wond3rboy!

Please take a look to this example, I believe that's what you're trying to accomplish

Kind Regards

Carlos O

Applications Engineer

National Instruments.

[wond3rboy]

Thanks carlos.

[JÞB]

Now if you want to GRAPH your data against time in excel you will need to change the example slightly.

The example writes timestamp as a string.  Excel then treats it as a string and not as a time.  Use "Time to XL.vi" availabe for download here, to convert a LabVIEW Time Stamp into the native time format for Excel.  when you first open the woorkbook time will look like a floating point number (because it is) just set the cell format to any convienient date or time format and it will display as a time or date