ActiveX Excel ChartWizard with XYScatter / 1 Series and X / Y values ???

[Estrakay]

I have two DataRows in Excel from Labwindows CVI like:

freq    attenuation

1        -1

2       -2

3       -3

etc...

I would like to make an XYScatter chart with smooth lines connected and 1 series with X and Y values (freq = X, attenuation = Y)...

I use the chartwizard function...

Excel_ChartChartWizard (ExcelChartHandle, &ErrorInfo,
         CA_VariantDispatch (MyDispatch),
         CA_VariantLong(ExcelConst_xlXYScatter),
         CA_VariantInt(2),
         CA_VariantInt(ExcelConst_xlColumns),
         CA_DEFAULT_VAL, CA_DEFAULT_VAL,
         CA_DEFAULT_VAL, MyVariant, CA_DEFAULT_VAL,
         CA_DEFAULT_VAL, CA_DEFAULT_VAL);

Ca_VariantInt(2) choose the tzpe of XYScatter chart but it has no connected lines... and i tested them from 1 to 8... nothing...

Also i don't know how to select to display only 1 series of source data in the chart ! There are always two series of data...

Please help me... i am loosing all my hair...

[RSteiner]

Hi,

I have the same problem generating a X/Y chart with the Excel_ChartChartWizard() function.

Are there any solutions meanwhile?