using SeriesCollection to plot arrays of data
after you successfully assign the array, look at the chart and select that
series. Look in the formula bar to see how your data is stored. The
maximum length of a formula is 1024 characters. I suspect you are bumping
up against this limitation.
--
Regards,
Tom Ogilvy
"Joe90" wrote in message
...
I was using arrays (sngle column) to specify the values to plot using
code similar to this:
ActiveChart.SeriesCollection(1).XValues = PosLvlMtx
PosLvlMtx was defined as a single array.
Whenever it got to the line ActiveChart.SeriesColection.NewSeries I would
get this error:
"Object Variable or With Block Variable not set"
PosLvlMtx had 17 rows. I then changed it to 14 rows and it worked
perfectly OK!
Has anybody else ever struck this problem? Anybody know of a workaround?
|