How to transfer data from a chart?

[ATElearner]

I am a learner of labview. I have already finished one of my test and the result is a  XY chart. Is there any way I can transfer those data from this chart to a spreadsheet or other file? Or if I need a spreadsheet result I have to reprogram it? What function I should use then. Is there a easy way I can just put sth in parallel wiith my chart indicator?

Thanks a lot.

[Will.D]

There is a vi called "Write to Spreadsheet File" which is pretty much perfect for your purposes.

You can find it in File I/O. 

Some programming may be necessary depending on how you want the spreadsheet to look.  But if you just want pure data, you shouldn't have to do much other than wiring up the "Write to Spreadsheet File" vi's inputs.

Message Edited by Novatron on 08-18-2005 01:31 PM

[ATElearner]

How about the data already in the chart? Can I find them somewhere?

[Will.D]

If you create a property node (right click on chart on block diagram->create->property node), there's an option called "History Data", which you can use to get the history from the chart.  This is limited however, by how large the history is.  If you right click on the chart on the front panel, there's an option called "Chart History Length" where you can change how many data points the chart holds in memory.

[ATElearner]

I think my question was not clear enough. I know how to set up "history length". I do know how to transfer the data already in  the chart to a spreadsheet or if I can find them somewhere.

[ATElearner]

I am able to transfer 1-D array to one column in spreadsheet by using "write to spreadsheet file" function. How can I load different arrays to other columns in the same spreadsheet? thank you.

[Will.D]

Build the 1D arrays into a 2D array, and then write them to a file.

Or, if you'll be doing this separately, read the 1D array back from the file, then build a 2D array, then write that to the fiel