Hi,

To avoid overlapping you will need to change the x and or y value of the
point. Add an offset value to either dimension to re-locate it. The
problem with that is that the point no longer truly represents the
values. How would the reader of the chart know which bubbles where
correct and which ones where shifted?
You could sort your data on bubble size (descending). This will not stop
the overlapping but should allow the smaller sizes to appear on top.

With data labels you can use 1 of 5 built-in label positions,
left/right/above/below/center. Or you can manually move it to any
position. There is no built-in function to detect and resolve
overlapping labels.

Cheers
Andy

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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info