I´ve a excel file that contains numeric values and date/time values.I've achieved to separate them and show them in a table on my VI, but I also need to plot this numerics values against those time values in a XY graph.How I can do it ? Thanks in advance
Can't open your attachment. What is an ".ace" file? Anyway, I think all that you'll have to do is some string to number conversions. A table is a 2D string array indicator and an XY graph can only plot numbers. The date/time will probably be the trickiest but look at the Date/Time to Seconds function.
I'm sorry Dennis, "ace" file is like a "zip" file, anyway ,I send you again in zip format. I`d like you to have a look to it,so you can understand it easier and you can help me. Thanks a lot
Try the attachment and see if that's about what you're trying to do. The one thing I didn't do but you'll have to is delete empty rows from your tables.
Thank you very much for your help.Your VI has helped me a lot, but I still can´t match data values in the excel file with the date values showed on the graph.Do you have any idea of how to do it? Thanks a lot
I ran your VI and all of the y arrays are empty and it's hard to determine what exactly you're trying to do. The use of all of those local variables doesn't make it any easier either. I would think about restructuring the program because even if you create data for the arrays, you might have a condition where the graph is drawn before the values are calculated.
Hi Dennis I don´t know why the VI doesn´t work properly in your PC,anyway what I´m trying to do is the following: I´ll got excel files with all columns filled with data and another column with date/time value (as you saw in the attachment).I´ve to show in the XY graph any column of the excel file versus according data/time value.The VI shows the data values correctly and doesn´t the acording time values but another very different date values. Thanks a lot
