How to display Excel data on waveform chart

[Dennis_Knutson]

Since you need to select columns, I'm not sure there is any need to read the file by lines. Just read it all at once so that the user can view all of the column's data. Once read, you can display x number of columns at a time, allowing the user to select which columns to appear in the final graph.

[rhupd]

@Munna: I've been working on the first vi you suggested.  Please see the attached.  From what I understand, I"m not specifiying a row but I'm specifying the 3rd column.  When I execute the VI, it shows data from the first column.  I also used probes and attached a screenshot.  Why do probes 23, 25 and 26 have 9 elements?  Where are they coming from?

Also, why can't I duplicate the y-axis?  I want to stack plots and show each column as a separate plot.

Thank you.

[Dennis_Knutson]

You are obviously not reading the context help. You have both row and column wired and you are getting a single element - not an entire column.

[rhupd]

Sorry, I uploaded the wrong version.  In this one, I don't have the row wired, only the column but I'm still getting the first column.

[Munna232]

Hi Rhupd,

Please check your Index array. You have connected two index arrays to For Loop. In that case you’re For Loop will executes based on Least array size.

And also, why your passing Index “0” many times (after Index 0)? Do you want to display Same signal (1^st Signal) many times?

[Dennis_Knutson]

And you really should be using a graph instead of a chart.

[Dennis_Knutson]

It's also very silly to have the read inside of a loop. Waste of resources.

Please review some of the basic tutorials.

[Dennis_Knutson]

It's also very silly to have the read inside of a loop. Waste of resources.

Please review some of the basic tutorials.

[Munna232]

Hi Dennis_Knutson

How we can display all Signals data in Graph at once (if Data size is very large)?

Suppose I have 100000x1000000 2D Array .. In that I want display 10 columns. How we can do it with “Plot Visibility Check”?

[Dennis_Knutson]

I wouldn't be using read from spreadsheet with 100000 columns. The original poster mentioned as many as 300.