View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?