Hi:

Set up yr data in two different series (A,B), assigning bubbles to each
different series. Ensure the bubble sizes are different. Format series B by
making the bubbles transparent (Right click the right series, Choose Format
Data Series / Patterns/ Area None) and make the line a contrasting colour to
Series A. Ensure the series B is on top of Series A (Right-click a series
and click Format Data Series / Tab "Series Order"). You will now see "empty"
bubbles on top of "filled" bubbles. Series A and B can be independently
labeled (and formatted for that matter). Right-click the label in the chart,
Choose Alignment and select the wanted position. Repeat for the other label,
obviously choosing a different label position than for Series A. This also
should work when bubbles partly overlap, or when one "disappears" behind a
larger one.
I hope this helps (I have Excel 2003).
vbr,
Henk

"Fullam" wrote:


Can anyone advise the best way of avoiding over lapping bubbles on a
bubble chart ?

I have a similar issue with the labels overlappinmg eachother


--
Fullam
------------------------------------------------------------------------
Fullam's Profile: http://www.excelforum.com/member.php...o&userid=33363
View this thread: http://www.excelforum.com/showthread...hreadid=532997