display graphs from excel data

[nagarjunapaleti]

Hi,

 I have the data in Excel(sample.xls). there are 2 columns of data. I want to read the data from excel and display in the form of XY graph (x-axis -one column of data and Y-axis one coumn of data).

can anyone please provide the VI for this or else give me procedure how to do this.

Thanks,

Paleti.

[shjukheter]

Hello Indian,

Make a search on forum "Reading .CSV file" and see where you end. You have lot of threads on this forum about this question. Take a look into File/O pallet.

[Bijay]

Hello,

Attached is a VI which you can refer.

Regards,

Bijay

[nagarjunapaleti]

Hello Bijay,

        Thanks for ur help. This vi is working for the file i have given previously. But it will be not working for all the files. Here i am attaching one more file. but it is not working for this file. I think the problem with the range. Please modify the VI so that it will work for all the files. Thanx once again for your help.

Thanks,

Paleti.

[A_Donfigulation_Error_Has]

Hi Paleti,

Bijay posted some sample code for you to get an idea of how to accomplish your application. Have you tried modifying it yourself yet? It's far more beneficial for you to learn how to do something than to have someone hand you the answers. Can you at least tell us what you have tried to get it working? Turning on the highligh execution may help you figure out how to fix the code.

Jason L.

[nagarjunapaleti]

Hi Jason,

  Actually my graph values has the scientific values on y axis.I have tried to change the display format of the x and y axis. And also i am new to the labview. I am finding hard to analyze the code. It should be ok to give some idea on how to change the sample code i can make it work for my application.  

Thanks 

Paleti.

[A_Donfigulation_Error_Has]

Nagarjunapaleti,

I think one thing that you may run into though is that you have incredibly small data to plot. Even when I try to open your .xls files, I get a prompt saying that they are corrupted and when I ignore the prompt, some data points just show up as "0.00000" because they are too small I'm assuming. Another thing that I think is going wrong because of this prompt is that both of your data points are showing up in the same Excel cell for me (all data is in a single column). Make sure these excel files are formatted the same way. Can you post a spreadsheet that does work for you? Make sure they are all formatted the same way.

Jason L.

[nagarjunapaleti]

Hello jason,

      Thanx for your reply. I will clarify what my concern is i need to display the graph with two columns(A-column as X-axis and B-column as Y-axis). I understand that Bijay provided example for waveform graph,and that is working for sample 3 data. when i use the same example for the different data like sample 1  which i am attaching below is not working. so i have tried to create the vi that will display the XY-graph instead of waveform graph. Still i am unable to display the graph. I will be attaching the VI i have tried. So anyone please help me to modify my vi to display as XY graph and make it work for the samples data i have provided in sample1.

Thanks & Regards,

Paleti. 

[nagarjunapaleti]

Hi Jason,

    Forget the last reply/message. I am fine now i can make it work.

Thanks,

Paleti.