Excel Graph non-sequential Columns

[charmand79]

Hi all,

I am trying to plot a graph in excel via Labview ActiveX components using say ColA as my x-axis data and Cols D and E as my y-axis data. My problem is that the Worksheet-Range method also includes the data of Cols B and C in the graph.  How could I omit plotting these unwanted columns?

PS. I know this is easily done using the Report Generation Toolkit however this would limit me to <4000 rows/cols plots which is unwanted in my case..

I have attached a zip file incl. a typical spreadsheet and my VI in case anybody wants to have a look.

Thanks a lot,

Harry

[Peter_W]

Hi charmand79,

I can't find any way to edit that range to skip the between columns since you can only specify it by the starting and ending cells. You could try adding a sequence ahead of the ones you are using that takes the data you want to graph and writes it to consecutive columns off screen, say AA AB and AC, and then graphs the range of those columns. That's a messy way to go about it but I believe it would get the job done. Also you could just reorganize the columns in the excel file, but I assume there are downsides to that which is why you are asking to exclude them instead.

Regards,

Peter W.

[charmand79]

Hi Peter,

thanks for the tip. I had a more comprehensive check in the forum and found a very helpful topic here that pretty much provides the solution. In a way, the solution is similar to what you proposed. It appears that a "dummy" plot with as many series as required must be created first using consecutive columns. Then the "real" plot is created by overwriting the "dummy" plot via the series.collection class.

I have added my VI in case anyone comes accross this challenge in the future. Must warn though that this VI looks pretty messy...

Cheers,

Harry