Hi

I'm trying to generate a 3D surface plot in VBA. When I
try to assign an address range to the XValues property of
a seriescollection, I get "unable to set the XValues
property of the series class". I am able to set the Name
Property, but not the XValue property.

The sample code snippet:
=============================
Charts.Add
ActiveChart.ChartType = xlSurface
ActiveChart.SetSourceData Source:=Sheets(sheetName).Range
(chartDataRange _
), PlotBy:=xlColumns

ActiveChart.ChartArea.Select

ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection
(1).XValues= "=RAW_ping_output!R5C9:R18C9"

===============================