Excel Insert Graph VI

[Eric1977]

Has anyone experienced the behavior of when using the Excel Insert Graph VI multiple times for different datasets that the graph will not always appear? When I run the below code, I see this behavior with a few graphs.

[ben64]

---

@Eric1977 wrote:

Has anyone experienced the behavior of when using the Excel Insert Graph VI multiple times for different datasets that the graph will not always appear? When I run the below code, I see this behavior with a few graphs.

---

Can you attach a LV2013 version.

Ben64

[Eric1977]

Even better...here's a 2012 version since that's what I think most use.

[ben64]

The issue is cause by the fact that you didn't wire anything to the column and row headers inputs. If you read the help file for the Excel Insert Graph VI the following is specified:

column headers specifies the text of the column labels on the graph. Leave this parameter unwired if you want to create an XY graph.

row headers specifies the text of the row labels on the graph. Leave this parameter unwired if you want to create an XY graph.

In your case you want to create an xlLine type graph but in fact you are creating an XY graph. Just wire something to the Row Column header inputs. See attached (LV2013).

Ben64

[Eric1977]

Ben,

The graph in your example is not what I am after. I do not need two lines of data in the same graph. I am only after one line being plotted per graph.

I was under the impression that the first row of data was the data points (1,2,3, etc.) while the second row of data was the actual data needing to be graphed (5,2,5,etc) and did not need the row and column inputs.

[ben64]

OK, I misundertood your post. I put your code in a for loop and made a couple of try and was able to reproduce the issue. Moving the New Report.vi and Dispose Report.vi out the the loop seems to solve the issue.

Ben64

[ben64]

I repeated it a few time with more graph generation and the issue is still there. Note that if you double-click on a blank graph it update correctly and the trace appear. The only thing I could think of rigth now is to add a wait ms function to slow down the loop a bit.

Ben64

[Eric1977]

I worked around my solution with using VBA code in Excel to generate the individual graphs since it was the more consistant, reliable solution.