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

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" <(E-Mail Removed)> wrote in message
news:71358bc6-a9a3-4c2f-954a-(E-Mail Removed)...
>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

On Feb 27, 9:58*am, "Peter T" <peter_t@discussions> wrote:
> 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
>
> "Revolvr" <Revo...@cox.net> wrote in message
>
> news:71358bc6-a9a3-4c2f-954a-(E-Mail Removed)...
>
> >I am using VBA to create somebubblecharts. The charts have 4series.
> > Creating the charts works fine except that sometimes one or more
> >seriesismissingfrom thechart, or some of the bubbles aremissing
> > from one or more of theseries. (It's always the same bubbles that are
> >missing).
>
> > If I save the file, close it, and reopen it, themissingbubbles
> > 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 abubblethat 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 4series. On small
> > datasets, this does not happen and the charts create correctly.
>
> > Is this a known defect? Is there a workaround?
>
> > I see this withExcel2000 andExcel2003 SP3 on WinXP.
>
> > Thanks


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.