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
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