Limit on array when using seriescollection.XValues and .Values met
 

Hi

I've been working around on this automated tool which gathers some data and
then is supposed to plot graph out of data. But the plotting part is really
giving me some headache. To be more specific runtime error 1004

It seems that somehow the size of arrays, to be excact the character count
of X and Y-values, implemented to the series is limited to (not sure, but my
educated guess would be) about 255-256 characters.

If possible, is there somebody who could prove me wrong (or right) so could
move on this matter. This is starting to feel like beating my head against
the wall.

Cheers

Limit on array when using seriescollection.XValues and .Values met
 

What do you mean by size of arrays? If you mean the number of X or Y entries
you could have, that's definitely not true. If you mean the formula, of
course all Excel formulas can't have more than 256 characters.

"Pasi Husso" wrote:

Hi

I've been working around on this automated tool which gathers some data and
then is supposed to plot graph out of data. But the plotting part is really
giving me some headache. To be more specific runtime error 1004

It seems that somehow the size of arrays, to be excact the character count
of X and Y-values, implemented to the series is limited to (not sure, but my
educated guess would be) about 255-256 characters.

If possible, is there somebody who could prove me wrong (or right) so could
move on this matter. This is starting to feel like beating my head against
the wall.

Cheers

Limit on array when using seriescollection.XValues and .Values
 

Thanks!

OK, I see, so I have to assign the values to the series some other way than
just assing arrays to the series Values & XValues-properties.

Thats what I ment, the characters in formula, and after a while of
investigation, I found it out myself also.

But how do I assing those values to series without using formula, because
assigning of a range also puts the values to formula (possibly, fails also) ?
And again thanks for a rapid replay.

--

Cheers


"salut" wrote:

What do you mean by size of arrays? If you mean the number of X or Y entries
you could have, that's definitely not true. If you mean the formula, of
course all Excel formulas can't have more than 256 characters.

"Pasi Husso" wrote:

Hi

I've been working around on this automated tool which gathers some data and
then is supposed to plot graph out of data. But the plotting part is really
giving me some headache. To be more specific runtime error 1004

It seems that somehow the size of arrays, to be excact the character count
of X and Y-values, implemented to the series is limited to (not sure, but my
educated guess would be) about 255-256 characters.

If possible, is there somebody who could prove me wrong (or right) so could
move on this matter. This is starting to feel like beating my head against
the wall.

Cheers