Can I keep the bubbles in my bubble chart from overlapping?

B

B_Gr

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.
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bubble Sizes in Bubble Chart 1
displaying hidden/smaller bubbles on a bubble chart 1
Doughnut Chart linked with the slicer in the pivot table 0
track changes bubbles don't extend margin 4
adding dynamic lines or quadrants to bubble chart? 2
How can I update my charts x axis (dates) automatically with new d 1
How do I name the Bubbles on my Bubble chart. 1
How do i "bring to front" bubbles in excel bubble charts which ar. 1

Top