05-01-2011 08:22 PM - edited 05-01-2011 08:31 PM
I have a Table Data which 5 columns, 1 string column and 4 double columns with header name. I try to graph the data in excel based on example from NI. When I use the data from NI example instead of my Data Table then it works. I research on convert 1D to 2D Array but I could not be able to do it.
05-01-2011 08:29 PM
You appear to be trying to use the Excel Easy Graph VI. However, it appears that you are connecting to the "start" input, which is the cell where the graph will be inserted. You need to wire to the "data" input, but you first need to convert your data to 2D. I don't quite understand the organization of your data. You said "5 columns, 1 string and 5 double with header name". This is not clear.
05-01-2011 08:35 PM - edited 05-01-2011 08:37 PM
I fixed the typos. How can I convert it into 2D Array, I tried the reshape accordingly to some old questions but it did not work for me.
By the way, it there any possible way to graph data in LabView?
Again, the Data Table contains 5 columns, 1st column data type is string (timestamp), 2nd, 3rd, 4th, and 5th are double
05-01-2011 11:52 PM
@LabViewRV wrote:
I fixed the typos. How can I convert it into 2D Array, I tried the reshape accordingly to some old questions but it did not work for me.
A Reshape Array can be used. You can also simply feed a 1D array into a Build Array function. That will give you a 2D array, but I do not believe that is what you should do here:
By the way, it there any possible way to graph data in LabView?Again, the Data Table contains 5 columns, 1st column data type is string (timestamp), 2nd, 3rd, 4th, and 5th are double
There are numerous ways to graph data in LabVIEW. Have you looked at the shipping examples and in the LabVIEW Help, or in the controls palette? You have a waveform chart, a waveform graph, and an XY graph. You can also have picture graphs. Is the source data a text file or an Excel workbook? If it's a text file you can use Read From Spreadhsheet File to read the file into a 2D array of strings. You can then convert the 1st column into time information, and the remaining columns into numerics. Please take a look at the examples. If you are still having problems, then post back what you have tried, and please provide an example of the data file you are trying to read and graph.