OLEVERB on chart

[Reillob]

Hello everybody,

I have a program made to generate a chart. The source of that chart is displayed this way : two columns to take, two to ignore, two columns to take etc.
The program runs pefectly with any sheet I used it on but as soon as there is more than a certain amount of colums (36 exactly) I get the Invalid OLEVERB structure error on the line :

Please Login or Register  to view this content.

I have been looking for that error and similar cases on the internet for two days now but I feel like its a hard one and that its really a case by case thing.

Here is the code that generate that error :

Please Login or Register  to view this content.

I have no clue where is the problem from because to me that error means that I go over the limit for an object but my range is not that big so...

I hope that its clear and that someone will be able to help.
Thank you for reading and don't hesitate if I have to be more specific.

Regards

[Reillob]

https://www.excelforum.com/excel-pro...ing-chart.html

I found this on the forum.
That person talks about 360 cells which is the exact same case as me.

My range is 10*36 cells and when under that amount there is no error.

I am in the same case, google is not helpful so I really rely on you guys.

Thank you

[xlnitwit]

Hi,

Can you rearrange your data so that the ranges are contiguous rather than every 4th column? I have a feeling you may be running into an issue with the length of the resulting SERIES formula due to your discontiguous ranges.

[Reillob]

Hi,

That's what I think too but my data needs to be arranged that way to be easy to read.

Maybe there is an other solution than the union range for my chart source that I don't know ?

[xlnitwit]

Perhaps you could copy and paste it elsewhere for use with the chart while maintaining the readable table?

[Reillob]

Didn't think of that, it will probably work.
I am a bit bothered by the extra step but thank you for that solution.

I think you are right about the discontinuous range. It doesn't look like that error is due to the quantity of data because I've tried to run my program with 50+ rows and everything goes well.