Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Over Lapping Bubbles and Labels
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Over Lapping Bubbles and Labels
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Over Lapping Bubbles and Labels
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to edit all 10 bubble data labels at the same time | Excel Discussion (Misc queries) |