READING DATA FROM A SPREADSHEET

[SSHADOR]

Hi everyone. I need trying to figure how to go about this situation. I created a VI which saves data in  a spreadsheet. The data has  25 rows and 3 columns.  Then I had read the data from the spreadsheet and display  graphically. The first column is  " Voltage", the second column is " Amps", and the third column is " Power".

I want to be able to display two graphs: One is" Voltage Vs Current" and the other is   "Voltage vs Power"

If any one can provided me with some guidance, I will really appreciate it.

Thanks

Vincent

[GerdW]

Hi Vincent,

read in the spreadsheet data as 2D array.

Then index the columns und bundle them to XY plots for a XY graph as needed…

[PalanivelThiruvenkadam]

Try this

[SSHADOR]

Thanks GerdW,

                      I am going to give it a try and provide you with a feedback.

[GerdW]

Hi Palanivel,

what are those FOR loops good for? You don't need them…

[PalanivelThiruvenkadam]

Hi Gerd You are rite... Thanks for reminding.

[SSHADOR]

Hi Palanivel,

                   Thanks for the help. The only thing I could not find was the figures attached to the For Loops. Are they supposed to X-Y Graph symbols of something else?

Thanks.

Vince

[GerdW]

Hi Vince,

you want to plot "x vs. y" data, so you should use XY graphs!

[SSHADOR · Accepted solution]

Huray!!, it worked. thanks to everyone who helped. Vince.

[Hooovahh · Accepted solution]

Thanks are given with kudos, and marking solutions.