Hi Emile,

The problem is that there is a limit to the length of the data series
formula. Integer values are ok but the floating point exceeds the
length. Therefore as you have discovered reducing the decimals or number
of points will allow it to work again.

Check out Jon Peltier's page for more detail.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

Emile van Mierlo wrote:
Hello group,

I encountered strange behavior with the Chart.SeriesCollection(n).Values and
XValues property when using floating point arrays.

When this procedure is run, the integer array works fine, but the floating
point array exits with the error message: "Unable to set the XValues
property of the Series class". The strange part is: if you decrease the
array size, it works, if you decrease the decimals, it works. The error
remains if the array is typed.

Anybody knows what's going on?

Thanks.

Emile

Sub drawAxis()

Dim xAxis(1 To 40), yAxis(1 To 40), n As Integer

For n = 1 To 40
xAxis(n) = 0.005
yAxis(n) = 5
Next n

Chart1.SeriesCollection(1).Values = yAxis
Chart1.SeriesCollection(1).XValues = xAxis

End Sub



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info