Use ActiveX to create a chart in excel

[Ryan_chenguang]

When I use ActiveX to create charts in Excel,there are many series those I don't want to create,I don't know why.As following are the code.Could some help to me to solve?

Chart aim is that create charts with three series ,but there is another 36 series in the chart.I changed the quantity series into 5 which in the chart template ,but there are also 36 series in the charts.

[kartiknattar]

Excel Row Col to range.vi is missing

[Ryan_chenguang]

Here is the VI

[RavensFan]

Have you tried using the debug tools such as probes and highlight execution to slow down the code and visualize the data on the wires?  My guess is that you aren't sending the values into the subVI that you think you are and a series you are creating contains multiple columns.

Perhaps there is a wiring error in one of the subVI's.  Your subVI's have a rather large number of connectors on their panels.  I recommend using clusters to bundle related data together into a single wire.  Also, correct datatypes.  In Excel Series.VI, axis rows and columns and plot order should all be integers, not floating point doubles.

PS:  The word is spelled "column" not "colum".

[Ryan_chenguang]

I saw the SUB VI,the data of all input is right,and the for loop go well as what it should be,the "plot order"is just finished at what I set,so that is why I thought is very strange.

The VI I will updated base on your suggestion after solve this problem.

[aputman]

Do you see something like "1st Qtr" "2nd Qtr" etc?  If so, this is the default dataset when you Insert->Object->"Microsoft Graph Chart" within Excel. 

I posted an example in another thread that let's you insert the nicer looking charts rather than the ugly OLE charts. 

[Ryan_chenguang]

Dears 

After change the range into I32 ,the chart goes well.thank you all!

But another issue in create new Excel file using ActiveX,I just use a Excel template and then save as another file ,then correct.

[Poema]

What did you exactly do to solve this, I have the same problem. Where do you set the range to I32.

Thanks,

Erik