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) |