Separating values from an excel file and plotting

[Simon1991]

Hello,

I am using the read excel table vi to read the values from an excel file.I see the data in the output.

I wanted to take the first two columns and multiply each value with 20m and then plot it in a XY graph. 

I am attaching the files below.

Thanks in advance 

[Gak]

Hi Simon,

If you are able to read the table then it is easy. Use index array function to get intended column and then use multiply function.

[Simon1991]

Hi Gaurav,

I used the index array function but the subarray will have the same data type as the input array and at the output i am not able to use the multiply function.

Is it possible for you to show me??

Thanks

[Simon1991]

Hello,

i acheived the multiplication in a different way but i have another problem.I am only considering two columns in the above excel sheet.After multiplying each value with 0.02  i get another array for the two columns with values say a,b,c,d and a1,b1,c1,d1 and so on.

The plot i require is of (a,a1)   (a+b,a1+b1)  (a+b+c,a1+b1+c1) and so on.

Any ideas that might help me.I am attaching the VI that solves the problem till multiplication.

Thanks in advance.

[Gak]

I have attached one vi. Let me know if it is helpful for you.

[Simon1991 · Accepted solution]

Hi Gaurav

This is what i did to get the output.May not be the conventional method but this is doing just fine for me.Thanks for looking into it.

Simon

PS

the text file should be in LVM format.coudnt upload it like that