READ SPREADSHEET

[labview1958]

I have a read spreadsheet.vi in LV6.0. When I RUN the data below in .txt I get TWO graphs. One is correct and the other is wrong. How do I remove the wrong graph. The vi is attached.

1 1
2 4
3 9
4 16
5 25
6 36
7 49
8 64
9 81
10 100

[GerdW]

Hello labview1958,

both lines look correct to me...

But maybe you need a Waveform graph instead of a chart or even better the XY graph?

[labview1958]

I am not able to find the sub vi between waveform graph and unbundle by name. It is not in my functions pallette on LV6.0.

[tst]

That function is an Index Array. It looks like that because it has a 2D array wired into it and because it has been extended by pulling it down.

[labview1958]

I have done the LV. I have attached it. It seems to work. Why the need for the transpose 2D array?

Also.

Can I change the black background graph with a white line graph to a white background graph with  a black line graph? Or for any other colour?

[tst]

The transposition is needed because the graph takes the data by rows, so unless you transpose it will see 10 rows (1,1; 2,4...).

Also, you made a wiring error. The Index Array should also get the value coming out of the transpose function. This is because if you wire nothing into the function, it also takes rows automatically, in this case rows 0 and 1. If you want to get rid of the transposition, you can wire 0 and 1 into the Column inputs of the function.

As for coloring the graph, go into the graph properties. First color the scales transparent, or to a proper color, so they're not in the way. Then, you can modify the plot color to black. Then, use the paintbrush tool on the graph itself to color the background white.