| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I keep the bubbles in my bubble chart from overlapping?
I'd like to create a bubble chart in which the bubbles don't overlap. I have
15 data points I need to include, and bubbles seem to be the only 3-variable chart available (I wish I could do bars where the bar width was linked to a 3rd variable - that possible?). Currently, the smaller bubbles are fine, but the larger data points are overlapping and even covering up some of the smaller ones right next to them. |
|
#2
|
|||
|
|||
|
If you sort your data high to low, at least the smaller bubbles will be
drawn on top of the larger ones, so they will not be completely obscured. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ B_Gr wrote: I'd like to create a bubble chart in which the bubbles don't overlap. I have 15 data points I need to include, and bubbles seem to be the only 3-variable chart available (I wish I could do bars where the bar width was linked to a 3rd variable - that possible?). Currently, the smaller bubbles are fine, but the larger data points are overlapping and even covering up some of the smaller ones right next to them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
| How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) | |||
Linear Mode
