If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bubble Charts Overlap
I'm in the process of plotting bubble charts in Microsoft
Excel. The problem comes when the bubbles (of varying sizes) start to overlap with one another if they intersect at similar X and Y coordinates, or in some cases, some bubbles are bigger in size overlap those that are smaller. Is there a way to work around this? (other than adjusting the x and y coordinates which is not possible) |
#2
|
|||
|
|||
Bubble Charts Overlap
Tan,
Maybe you could create a copy of your x,y,size data and sort it on the bubble size (descending sort). At least parts of the bubbles would appear when overlapped. Although with points having identical x,y,size values one is always going to be obscured by the other. Brainwave whilst writing this! You could use transparent bubbles. But transparency fills are not supported. A work around is to use a custom marker. Use Autoshapes to create a circle on a worksheet. This can have transparent fills, so format as required. Now select and copy shape, CTRL+C will do. In the chart select the data series and paste, CTRL+V, to apply autoshape to markers. If you need an example check out Jon's page. (http://peltiertech.com/Excel/ChartsH...omMarkers.html) Tan wrote: I'm in the process of plotting bubble charts in Microsoft Excel. The problem comes when the bubbles (of varying sizes) start to overlap with one another if they intersect at similar X and Y coordinates, or in some cases, some bubbles are bigger in size overlap those that are smaller. Is there a way to work around this? (other than adjusting the x and y coordinates which is not possible) -- Cheers Andy http://www.andypope.info |
#3
|
|||
|
|||
Bubble Charts Overlap
If the data are such that the bubbles overlap, what would you expect as
a 'solution?' Also, in the chart, double-click on the bubble series, then in the resulting Format Data Series dialog box, select the Options tab. See if the 'Size represents area/width of bubbles' helps. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I'm in the process of plotting bubble charts in Microsoft Excel. The problem comes when the bubbles (of varying sizes) start to overlap with one another if they intersect at similar X and Y coordinates, or in some cases, some bubbles are bigger in size overlap those that are smaller. Is there a way to work around this? (other than adjusting the x and y coordinates which is not possible) |
#4
|
|||
|
|||
Bubble Charts Overlap
Oh, one more item.
In the chart, double-click the bubble series, then, in the resulting dialog box, select the Options tab. In there, experiment with 'Scale bubble to x% of default.' -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I'm in the process of plotting bubble charts in Microsoft Excel. The problem comes when the bubbles (of varying sizes) start to overlap with one another if they intersect at similar X and Y coordinates, or in some cases, some bubbles are bigger in size overlap those that are smaller. Is there a way to work around this? (other than adjusting the x and y coordinates which is not possible) |
Thread Tools | |
Display Modes | |
|
|