Excel Chart Series XValue and Value Question

[Fatum48]

Hi everyone!

I'm Working on a Excel project including many Charts added dynamically into sheets.

So far so good I can add the charts where I want and add series to them (I'm talking about charts of the style "Line with markers)

Usually in VBA I can set those values on a serie:

XValues = someRange

Values = someRange

Here's my code:

$oChartRng = $oSheet2.Range("H" & $oStoreDataDestRng.Row & ":P" & $iStoreAvgRow)
        $oNewChart = $oSheet2.ChartObjects.Add($oChartRng.Left, $oChartRng.Top, $oChartRng.Width, $oChartRng.Height)
        $oChart = $oNewChart.Chart
        $oChart.ChartType = 65
            
        
        For $j = 1 to 4
            $oNewChartSerie = $oChart.SeriesCollection.NewSeries ;- Working

            with $oChart.SeriesCollection($j)
                .Name = $aChartSeriesName[$j] ;- Working
                .Values = $aChartSeriesRng[$j] ;- Not Working
                .XValues = $aChartSeriesRng[0] ;- Not Working
            EndWith

        Next

The $aChartSeriesRng variant in an array filled with Range objects (which is working in VB) and seems to work in AutoIt also cause I can MsgBox(0,"",$aChartSeriesRng[$j].Address)

I've been searching all around the forum to find how to tell Autoit to assign the XValues and Values to a series and I did not find nothing about it. Ime wondering why the .Name is working and not .XValues or .Values

Usually AutoIt syntax for Excel is pretty near than VBA Syntax

Thanks very much for your help!

[PsaltyDS]

Add a COM error handler (see OBJ\COM Reference in the help file) and see if you get more detailed failure indications.

You might also do something like this to see if the object type is as expected:

ConsoleWrite("Debug: ObjName = " & ObjName($oChart.SeriesCollection($j)) & @LF)

[ValeryVal]

I'm Working on a Excel project including many Charts added dynamically into sheets.

About embedded Excel, Chart under AutoIt3 see

AGraph_OWC_Embedded.au3