| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error in XValues
Hello,
I'm trying to create an Excel chart ... When I write the following code: GRAPH.Chart.SeriesCollection(1).XValues = XLAPP.Worksheets("Raw Chart Data").Range("b1", "cz1") I get 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
error in XValues
Try syntax:
........Range("B1:CZ1") "nanz" wrote: Hello, I'm trying to create an Excel chart ... When I write the following code: GRAPH.Chart.SeriesCollection(1).XValues = XLAPP.Worksheets("Raw Chart Data").Range("b1", "cz1") I get 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error accessing external object property XVALUES | Excel Discussion (Misc queries) | |||
| XValues Property and 400 Error | Charts and Charting in Excel | |||
| (Un)usual "cannot set Xvalues" error message | Excel Programming | |||
| Error 1004: Unable to set the XValues of the Series Class | Excel Programming | |||
| XValues and values. | Excel Programming | |||
Hybrid Mode
