Report Generation tool, Excel Specific

[Joe_Guo]

Sorry, there was an error in the previous code. Here is the working one, along with the wrapper that calls the subVI.

[ctailor]

Joe,

Sorry, I was out sick yesterday.

The Vi works! Thanks a lot!

One thing though, at first I didn't realized that there were three graphs on top of of each other. When I checked the source data for all graphs, somehow it points to the last two series. In antoher words, all three graphs sourced data from the same two series which refering to deeper mode X1 Y1 and Deeper mode X2 Y2. Is it because it is overwriting the data?

Is it possible with VBA to run subroutine three times for each mode where I could define no of series, location and no of sample separately. Please know that user can take 11 samples for one mode but may only run one series with 8 samples in se
cond mode.

Without your help, getting this far was not even possible as I don't know VBA. I appreciated your help so far.

Again, thanks a lot!

-Chetna

[Joe_Guo]

well, that's why the vi is just an example. the input to the RUN VI are for demostration purchases only. You need write some code (or if the data is always at the same location, then you probably can hardcode the inputs) to tell the function which sheet is the data sheet, the titles and where the first row of data starts, how many data sets, etc. Also, the plot posistion depends on where the first row the data is for that plot. If you used the same first row as input, then every plot will be overlapped.

Play with the example vi, and modify the inputs and see what happens.

joe

[ctailor]

Joe,

Thank you very much for your help. It was indeed very useful. Again, thanks!

-Chetna