LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Plots in waveform graph from excel table

Solved!
Go to solution

Hi there. I try to build plots in waveform graph with using excel table. In table there are date colomn and 8 other colomn for sensors level. Date colomn has dd/mm/yyyy hh:mm:ss.000 format. 
I can get excel table in labview. Else i can build plots of sensors level. But i can't build this all together ( plots doesnt depends from date ). Please could sombody here to help me? Thank you. Sorry for my english.Smiley Sad

Download All
0 Kudos
Message 1 of 7
(3,388 Views)
Solution
Accepted by topic author teslo

Hi teslo,

 

your VI is way too much complicated!

 

See this:

check.png

Don't forget to format the x axis of the XY graph to show timestamps…

 

- Why do you need all those 2D arrays for data columns?

- Why do you need all those FromDDT/ToDDT functions to convert arrays?

- Why do you transpose the Excel data instead of just indexing columns?

- Why is your conversion from string to number this complicated?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 2 of 7
(3,385 Views)

Hello GerdW, sorry i staddy labview  myself, i\m bigeener. Thanks for your answer. But when i try your vi. It make only one point on XY Graph, why? if it is not hard for you could you explain me that? Thanks again. It is important for me.

0 Kudos
Message 3 of 7
(3,377 Views)

And i want use waveform graph. Thanks.

0 Kudos
Message 4 of 7
(3,376 Views)

Hi teslo,

 

i want use waveform graph.

Why?

Your data uses non-uniform spaced timestamps, so a XY graph is the natural choice!

 

My snippet shows just the conversion of your "Excel" data to a plot. You need to implement it in your VI…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 5 of 7
(3,368 Views)

Oh sorry. It's okey. You are rihgt. I did mistake. But how i can use waveform graph?

0 Kudos
Message 6 of 7
(3,367 Views)

Hi teslo,

 

how i can use waveform graph?

Build waveforms and plot them in the graph…

😄

(LabVIEW comes with a huge library of example VIs. Did you learn from them?)

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 7 of 7
(3,360 Views)