Wierdness when adding data in serieses to x-y charts using V

[LLoyd]

I am calling a function that ReDims and array and loads it with data from a worksheet.

I am then creating a new series on my graph:

dim pNewSeries as Series
pNewSeries = Charts("MyGraph").SeriesCollection.NewSeries

and loading it with my arrays:

pNewSeries.Values = DynamicArray1 pNewSeries.XValues = DynamicArray2

This works fine, but only if the number of points in my arrays is no greater than 14.

What on Earth is going on?!!


LLoyd

[Damon Ostrander]

Hi Lloyd,

There is a limit to the size of an array that you can assign to the Values or XValues properties. Unfortunately, Microsoft does not document many of these limitations in the helps. In the past when I have wanted to plot data from a large array I have had to write it to a worksheet and assign the Values and XValues properties to the corresponding worksheet ranges. Of course, all of this can easily be done from within VBA, and the data can be written to a hidden worksheet so the worksheet functions as a pseudo-array.