From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Plotting Data vs Time in Excel

Solved!
Go to solution

Hello Community,

 

My question seems rather simple: I wish to plot (not in a graph, just regular values next to one another) collected data vs the time they were aquired.

 

My problem is that I take my samples one at a time, creating 1D-data, and therefore cannot use the 2D-data option on the 'write to spreadsheet' vi. Instead of having one column for Voltage and one column for the Time, both values just plot alternatingly in one column (see attached photo.)

 

Are there any suggestions as to how I can fix this quickly and easily without having to manipulate the entirety of my simple vi?

 

Thanks for any help!

 

(I have attached a snippet, my vi, and a picture that shows how the data plots right now instead of how I want it to.)

0 Kudos
Message 1 of 3
(2,497 Views)
Solution
Accepted by topic author StudentWithLasers

You have True wired to  the 'Write to Spreadsheet File.vi's 'transpose?' input. Wire a False to that instead.

Message 2 of 3
(2,481 Views)

That did the trick, thanks so much!

I never would have spotted that little bugger otherwise.

0 Kudos
Message 3 of 3
(2,454 Views)