LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SeriesCollection question EAB1977 Charts and Charting in Excel 2 December 22nd 08 02:29 PM
Reading data arrays from multiple data files in excel Hankjam[_2_] Excel Discussion (Misc queries) 0 February 7th 08 08:29 PM
Creating a plot in Excel with SeriesCollection CLamar Charts and Charting in Excel 2 June 12th 06 05:56 PM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
calling seriescollection by name R.VENKATARAMAN Excel Programming 2 January 13th 04 01:29 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"