waveform chart to excel

[Harold_Timmis]

I need to put my waveform chart data into an excel graph?

does anyone know how this can be done?

please help,

Harold Timmis

GE Transportation

[Drewski]

You can use the Get Waveform Components to isolate the data (Y) and then use the write spreadsheet file.vi to write the data to a spreadsheet file.  Next, open the file in excel, then use the graph wizard, usually line graph works best.  You may need to set the transpose option on the write spreadsheet file.vi if the data comes out in one row instead of a column.

Good Luck! 

[Harold_Timmis]

where is Get Waveform Components i am using Labview 8.0 

[Harold_Timmis]

It also has to open up excel automatically and put this graph on automaticall and than put the data on the Excel graph?

[Drewski]

Get waveform components is under the waveform set of tools.

Go to the block diagram, programming -> waveforms -> Get Waveform components. 

[Harold_Timmis]

this will work except it has to do it all automatically

[Drewski]

Harold Timmis wrote:
It also has to open up excel automatically and put this graph on automaticall and than put the data on the Excel graph?

---

Huh? Why does it have to be in Excel?  I believe you will find it a bit difficult to automagically copy and paste data from LabVIEW to Excel without a third party active x control or some other sort of helper application.  Any reason you can't print the front panal of the vi that has the graph on it?  You can manipulate the colors of the chart of graph to look more excellish, remove the black background for one, use a thicker line for another.

[Harold_Timmis]

funny enough i thought the same thing but my manager wants it to go in excel even though i have a print function and also i have it to where it saves the data in an excel format but he still wants it to all export out to excel I dont know why? and i know it is hard to export data out to excel without the Report Generation Tool kit i have reviewed several hundred VI's that say this exports data but none have what i need.

[krispiekream]

here..

do this

 

Message Edited by krispiekream on 11-14-2008 01:58 PM

[Drewski]

Well maybe you could do some visual basic coding on the excel side that when the excel spread sheet is opened it looks in a folder to see if there are any new data files and if so, pulls those data files into a new worksheet and makes the graph every time it is opened?

Or have the manager buy the report generation tool kit?