06-09-2011 10:10 AM - edited 06-09-2011 10:12 AM
Well using your VI, my chart looks also good. But after copy-pasting it into my VI I'm getting this (see attachement). The Diameter should be around 11 while the distance is constantly increasing up to 1 (mm)
06-09-2011 10:32 AM
Ooooh maaan....i've finally got it working. I had to transpose the array before sending it to the Excel Easy Graph VI. I was trying to transpose it before sending it to the Excel Easy Table VI, but it's obvious that it doesn't have to do anything to do with that. Im such a moron :D.
What i want to do next, is this: After saving the Data in the excel file, the User should be asked if he wants to do another measurement. If yes, the new data has to be stored in the same file, but a different worksheet. How do I do this?
06-10-2011 01:37 AM
Thats what i meant with the transpose array
The next steps are quite easy... with the "one button dialog" you can prompt the user and ask him if he want to do a next measurement... and with the "Excel get Worksheet" you can select the active worksheet.
06-10-2011 03:51 AM
Can you show me an example of how i can jump back in a sequence structure?
06-10-2011 04:03 AM
Just add a While Loop around the sequence you want to repeat. When i look at your programm you should make a state machine out of it, then it will be much easier.
06-10-2011 04:50 AM
Hello,
You can draw a chart or graph in LabVIEW and pass the reference to the excel file as an Image.
I have attached one example please see it. May be it solve your problem.
06-10-2011 06:14 AM - edited 06-10-2011 06:14 AM
Well yes, i know, a statemachine would be a better solution for my program. Unfortunately I don't have much time left to finish the program, so reprogramming the whole thing is not an option. By the way thanks for the screenshot, but will the data be saved in the same excel file? I tried it with a for-loop by asking how many measurements the user wants to do, but instead of writing the data into a new worksheet, the programm opened as many excel files as the user defined how much measurements he wants to do. Additionally the data besides the first excel-file was jibberish.
06-10-2011 06:28 AM
That's because you haven't specified a Excel File on the New Report.vi (template input).
You have 2 oportunities:
1. You can specifie an Excel File
2. Only Open and Cloe the Excel file one Time. Open it, then make all the measurements and the Cloe it. Look at the screenshot