| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
displaying hidden/smaller bubbles on a bubble chart
Hi all,
is there any way to display bubbles that have been covered by bigger bubbles so that these too show on the chart? I can think of manual ways such as changing the values of the smaller bubble so that it displays and then adding a note to clarify the real values. I've also reducing the bubble scale to 45%. With this percentage, the bubble does appear, but the quality of the chart diminishes as all other bubbles appear much smaller than their original size... Thanks, Kalan |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
displaying hidden/smaller bubbles on a bubble chart
Hi,
What about if you sort (descending) the data by bubble size? Cheers Andy kalan wrote: Hi all, is there any way to display bubbles that have been covered by bigger bubbles so that these too show on the chart? I can think of manual ways such as changing the values of the smaller bubble so that it displays and then adding a note to clarify the real values. I've also reducing the bubble scale to 45%. With this percentage, the bubble does appear, but the quality of the chart diminishes as all other bubbles appear much smaller than their original size... Thanks, Kalan -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with BUBBLE CHART scale and legend | Charts and Charting in Excel | |||
| Pie chart not displaying % in spreadsheet | Charts and Charting in Excel | |||
| How do I name the Bubbles on my Bubble chart. | Charts and Charting in Excel | |||
| Can I keep the bubbles in my bubble chart from overlapping? | Charts and Charting in Excel | |||
| ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
Linear Mode
