Bubble Charts - Series and Bubbles Missing (sometimes)

[Revolvr]

I am using VBA to create some bubble charts. The charts have 4 series.
Creating the charts works fine except that sometimes one or more
series is missing from the chart, or some of the bubbles are missing
from one or more of the series. (It's always the same bubbles that are
missing).

If I save the file, close it, and reopen it, the missing bubbles
appear!

However I am also adding labels to each data point. In the code I get
an error when it tries to add a label to a bubble that should be there
but isn't. So saving, closing, and reopening is not a good workaround
since I have to manually add the labels.

I have tried adding "Application.CalculateFull" to the code but that
doesn't help.

The problem seems to be with charts that have more bubbles. One
dataset I am using has about 50 bubbles in 4 series. On small
datasets, this does not happen and the charts create correctly.

Is this a known defect? Is there a workaround?

I see this with Excel 2000 and Excel 2003 SP3 on WinXP.

Thanks

 

[Peter T]

Based on what you say about only it's only wit a lot of bubbles some are
missing, and I recall from your post yesterday you are adding them
programmatically, one reason for some missing bubbles would be if the R1C1
formula exceeds 255 characters (incl the "=").

However, if that's the reason I don't see how they would appear after
save/close reopen.

Regards,
Peter T

 

[Revolvr]

Based on what you say about only it's only wit a lot of bubbles some aremissing, and I recall from your post yesterday you are adding them
programmatically, one reason for somemissingbubbles would be if the R1C1
formula exceeds 255 characters (incl the "=").

However, if that's the reason I don't see how they would appear after
save/close reopen.

Regards,
Peter T

Yes, very weird. Let me clarify that I find it is not the entire
series missing but most of the bubbles from some series. Usually there
is at least one bubble of each series.

When I look at the Source Data manually everything is there.