How can I create an excel graph using Report Generation that can hold more than 3,999 points per row/column?

[LaRosa]

My VI reads in 2 channels of time domain data at 100Hz.  The tests last anywhere from 250-300 seconds, so this is maximum around 30,000 points of data per column.  I would like LabVIEW to automatically generate an excel report each time I run the test that will include the 3 columns of data (time, ch1, ch2) and a corresponding xy graph of channel 1 and channel 2 vs. time.

I realized after writing all the code that the MSGraph can only handle something like 3,999 points of data per column.  Is there anyway I can accomplish what I've described above without having to manually code an excel template?

Thanks.

[Mellobuck]

LaRosa,

I was trying to replicate your problem, and I was able to graph two columns of 25,000 points each. Could you be more specific about where the size error shows up?

[LaRosa]

Mellobuck,

Were you using Report Generation vi's to graph the data in excel?  If I use the "Insert Graph" vi and other Report Generation vi's for MS Excel, then it simply won't graph more than 4,000 some odd data points.  I don't really understand why, since you can graph essentially as many points as you wish in Excel itself.

I don't get an error, persay.  Instead, once I stop my VI the report will pop up and the chart will be empty where there should be a graph of the data.

[Darren]

In addition to sending the large columns of data to Excel, I recommend decimating the data and sending the decimated data to the graph directly.  You can decimate the data to the point that it takes up less than 4,000 points, yet you'll still be able to see a good visualization of your data, since the best resolution you'll have on the graph is the number of pixels in your display, which is surely less than 4000 pixels wide.

Hope this helps,
-D

[AdnanZ]

LaRosa,

Microsoft Graph cannot contain more than 4,000 rows or columns, including row and column headers. It is a limitation of the Microsoft Graph component of Excel.

Here is a post which points to a solution:
How to generate graph in Excel with more than 4000 points

Other workarounds are:

1. Instead of using Microsoft Graph you can use a graph in LabVIEW and then attach the LabVIEW graph to a report using the Report Generation Toolkit.
   
2. A second option is to export the data to an Excel worksheet and then manipulate the data in Excel.
   
3. Decimate the data such that it is represented by less than 4000 data points before sending to MS Graph.
   
4. Finally if the application requires manipulation for large amounts of data, Diadem might be a better solution because it is tailored for larger amounts of data.