LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Error -2146827284 with report generation 1.1.4

Hi. Im working with Report Generation 1.1.4 and I was testing it for exporting data to an excel book. I was making some vi's to learn how to use it and do what I need it for. I need to take two non constant numeric values and save them in an excel table of two columns and graph them. The error comes when I transpose the original matrix, so i can have 2 columns instead of 2 rows in excel. In the picture you can also see that no graph is displayed. If anyone knows has experience doing this kind of activities between labview and excel I would appreciate some help! Thanks!
Download All
0 Kudos
Message 1 of 3
(2,941 Views)

Why are you turning your array into a matrix?  A matrix is not the same thing as an array.  (They are related, but are not truly the same thing.)

 

Turn on context help and read about all the inputs into the charting function.  You want to have a 2-D array.  You are actually only starting off with a 1-D array.  (Which you can't transpose if you wanted to because it is only 1 dimensional).  Create a 2-D array of data to feed into the charting function.  If you need to transpose that you can.  Don't play with matrix transformations, they are rarely used and only for special math operations when they are.  Wire up any other inputs to the charting function as needed.  The default chart type is xlColumnClustered which I am going to guess is not truly the graph you want.  You probably want an XYscatter.

0 Kudos
Message 2 of 3
(2,934 Views)
Hi. What I need is that two different magnitudes be plotted vs time. How can I make a 2d array for each magnitude? I was checking one example of a excel report generation vi and they do it but using a table, so they enter the data manually, they fill it first and then run the vi, and the excel file is generated. My data is coming from an instrument and is changing continuously, so i basically I want to take like 10 samples and plot it. Thanks!
0 Kudos
Message 3 of 3
(2,912 Views)