Excel: Add a Chart for the selected data...

[fotinaki]

Hello,

I'm trying to create an Excel chart ...
I'm based on the
"Create an Automation Client for Microsoft Excel"

When I write the following code:
oSeries.XValues = oSheet.Range("A7", "A22&quot
nothing changes to the generated chart (same result when I leave out this line of code!) and I don't take the values of this column (A) to the axis X... Where is the error?

I have 2 series so I tried the following:
.SeriesCollection(1).XValues = oSheet.Range("A7", "A22&quot
.SeriesCollection(2).XValues = oSheet.Range("A7", "A22&quot

but I take this error:

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in microsoft.visualbasic.dll

Additional information: Type mismatch.

Please, can anybody help me?

Note: I found that this error is a bug of MS but I didn't understand what I'm supossed to do to correct it...

Thank you