What is "thisDataSet"

If it's a horizontal array that'll end up writing values to the series
formula it'll fail when that section of the string tries to exceed 255
characters, including the curly brackets and commas. There is a different
approach but quite a lot of work.

Regards,
Peter T

"Mitch" wrote in message
...
I have an existing macro that charts user selected data after perfroming a
few 'conditioning' functions. The macro works for low numbers of data
points
but does not work for series' with large numbers of data points (30 for
example). The data range is read from any Excel workbook into a memory
array
named thisDataSet. 'thisDataSet' is redimensioned earlier in the macro
following elimination of unwanted data points. That part produces the
correct array size and the correct data points. I use the following code
to
populate the chart series values:
Charts.Add
ActiveChart.SeriesCollection(1).Values = thisDataSet
When the macro does not work it always stops at the
ActiveChart.SeriesCollection line and gives the message:
Run-time error '1004': Unable to set the Values property of the
Series
class.
Any suggestions will be appreciated.