12-02-2019 12:15 PM
yup i have done but my graph is still wrong
heres my vi and csv file
12-02-2019 08:33 PM
Some comments:
Bob Schor
12-02-2019 09:45 PM
hi i have changed my csv data but my graph x axis still cant seem to read from the timestamp.
please help me to take a look
12-03-2019 01:35 AM
Hi jasper,
this new CSV file basically has the same content/formatting as the one attached at the start of this thread.
So also my suggestion from message #3 still applies…
(The only difference in the new CSV file is the additional (but empty) column due to those trailing comma in each line/row!)
12-03-2019 11:39 AM
Is this what you expect to see? [I did this quickly, so the time is "elapsed time" since the start of the data ...]
Bob Schor
12-03-2019 10:35 PM - edited 12-03-2019 11:19 PM
nope i only need data from 8am-9am using this csv file
12-04-2019 01:38 AM - edited 12-04-2019 01:40 AM
Hi Jasper,
quick adaption of my previous suggestion:
Using just the "nice" part of your data to determine the dt…
Your latest CSV is still malformed, see the last lines in the file:
1/11/2019 8:59,349.78,
1/11/2019 8:59,359.3,
1/11/2019 8:59,361.73,
1/11/2019 8:59,355.94,
1/11/2019 9:00,381.69,
1/11/2019 9:00,392.2,
1/11/2019 9:00,390.48,
1/11/2019 9:00,385.22,
2/11/2019 9:00,394.93,
3/11/2019 9:00,405.88,
,,
The last line contains empty cells.
There are still empty cells in column 2.
The two lines before the last line contain just one sample per day, while the data before are sampled at 4 samples per minute. This will give "not so nice" looking graphs and makes it harder to use waveforms…
Recommendation: Save the data using more precision in the timestamps!
12-26-2019 10:55 PM
Hello guys need help with xy graph which read from the excel file and able to prompt the ambient temperature and also the irradiance(w/m^2) respectively in a single program using only 8-9am data. I have attached an excel file below. Thank You!
12-27-2019 08:28 AM - edited 12-27-2019 08:44 AM
Hi Jasper,
You have previously created a trend on this from the LabVIEW forums https://forums.ni.com/t5/LabVIEW/read-from-excel-and-plot-xy-graph/td-p/3992256/page/2
Bob and Gerd have previously posted the solutions for your problem when I look through the trend...
Do refer to this link here I attached https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000PAiESAW&l=en-SG
Attached the VI and detail what problem you are facing with the VI instead so that we could help you from there...
12-27-2019 08:30 AM - edited 12-27-2019 08:45 AM
I suggest you get a firm understanding of the basics of LabVIEW first before attempting on writing a VI....