Control ActiveX/Excel plot legent number of plots

[anon2016]

Hello,

I am trying to familiarize myself with ActiveX & excel and I am using a vi (attached) that I found online. and when I run it excel opens up and in the graph the plot legend has 7 plots listed instead of 1. How can I change this to go according to the number of plots I actually have?

Thank you in advance

[ben64]

---

@anon2016 wrote:

Hello,

I am trying to familiarize myself with ActiveX & excel and I am using a vi (attached) that I found online. and when I run it excel opens up and in the graph the plot legend has 7 plots listed instead of 1. How can I change this to go according to the number of plots I actually have?

Thank you in advance

---

It's just a formatting issue in the rows and column arrays. If you right click in an element of each array and select "\" Codes Display you will see that there are some newline characters (\n) at the end of the columns headers and that the  NB PLL string is repeated twice with a \n between the repetitions and at the end. In this case delete everything after the first PLL. That's what's causing the issue.

Ben64