Hello,
Im trying to create an Excel chart ...
Im based on the
"Create an Automation Client for Microsoft Excel"
When I write the following code:
oSeries.XValues = oSheet.Range("A7", "A22")
nothing changes to the generated chart (same result when I leave out this line of code!) and I dont 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")
.SeriesCollection(2).XValues = oSheet.Range("A7", "A22")
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 didnt understand what Im supossed to do to correct it...
Thank you
Im trying to create an Excel chart ...
Im based on the
"Create an Automation Client for Microsoft Excel"
When I write the following code:
oSeries.XValues = oSheet.Range("A7", "A22")
nothing changes to the generated chart (same result when I leave out this line of code!) and I dont 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")
.SeriesCollection(2).XValues = oSheet.Range("A7", "A22")
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 didnt understand what Im supossed to do to correct it...
Thank you