fotini Posted July 30, 2003 Posted July 30, 2003 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") 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") .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 didn't understand what I'm supossed to do to correct it... Thank you Quote la grecque
lal bhi Posted October 12, 2005 Posted October 12, 2005 Re: Hi Fotini, I am facing the same problem. Were you able to find a solution to it? It would be really helpful. Thanks Lal Bhi Quote
Recommended Posts