Need help with report generation toolkit

[Flasher]

I'm having a really hard time finding a solution for my problem. I'm measuring a distance and a diameter simultaneously. The outcoming values have a depency and are stored in a 2-D array.  I want to export this array to an excel table and x-y-chart (distance is x and diameter y). So far I can export the data to a table, however the charts produced are useless. Can somebody please help me? I'm almost crying since I'm trying to find a solution for 3 days now.

Additionally, after one measurement is done, the user should have the possibility to do the next measurement, and the data has to be stored in the same excel file, in another worksheet. How can I do this? 

[Method M]

Hello,

I think you want to do something like this. I attached the VI.

Regards

[Flasher]

Thx for the VI but I can't open it - im using Labview 2009. Can you please convert it?

[Method M]

Here's the VI for LV 2009

[Flasher]

Thx a lot. Well it's kinda what I want to do (and what I did), but the xy-chart has to be in excel. So far my VI is producing for every data-pair an own graph, which is of course nonsense. I seem to have a problem with the incoming data, which is coming out of the array. Can somebody please take a look at my VI (first post)?

[EvenDeejay]

Hi!

If you want a nice graph in Excel based on your data you have input there, I would recommend creating a macro that builds your graph. Read more about macro, Excel and LabVIEW here. I don't have the Report Generation toolkit, but I think you can send macros with it too. 

[Method M]

Don't bundle the Data. Index the Diameter and Distance, after that you've got 2 Array. One for the Diameter and another for the Distance. Then you can bundle these 2 Array to a cluster for the XY Graph

[Method M]

Or try to add a "transpose 2D Array" before you write the Graph into Excel

[Flasher]

transposing the array doesn't help - only the data in the table gets flipped from vertical to horizontal listing. What do you mean by clustering two indexed arrays? I'm trying to do that but the "number to fractional string" thing doesn't accept a cluster, even converting the cluster to an array doesn't help 

[Method M]

when i do this, my XY Chart in Excel looks fine. So that i'm sure what you wanna do: You just want to save your Data in Excel as an XY Chart?