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