Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SeriesCollection question | Charts and Charting in Excel | |||
Reading data arrays from multiple data files in excel | Excel Discussion (Misc queries) | |||
Creating a plot in Excel with SeriesCollection | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
calling seriescollection by name | Excel Programming |