Question for active X excel experts

[joeycao]

My question is this how do I create multiple charts on the same page using Labview?  Please look at my program to get a better idea of what I like to do.  Basically I have 2-D array of clusters of 4 elements (Y1, Y2, X1, X2), which define the range of the plot.  Each row in the 2-D array has 2 clusters which will be plotted as series 1 and series 2 on a plot.  I am indexing that two dimention array to creat multiple plots, each of which contains two series/graphs.

JC

[SamboNI]

Hi joeycao,

To get a general idea of which sequence of commands you'll need to use to create these charts and configure them as you like, your best bet is to record a macro in Excel, doing the steps, and then later examine which are used. You'll then be able to use invoke nodes to make these ActiveX calls in the proper sequence.

Please refer to this knowledgebase, Using National Instruments Software to Control Microsoft Excel with ActiveX
for a description of how to do this.

Hopefully that gets you started on the right path.