[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Report bubble overlap

I have a problem on my bubble chart. Bubbles are overlapped for those that have the same values. I tried different colors or shapes or transparency... it won't work well. Overlapped is still there. Is there any way to resolve the problem? Thanks.
1 Solution
are you sure a bubble chart is the most suitable type to display your data? Bubble charts are good if you have 3 variables/dimensions that you want to show simultaneously.  Otherwise you should use something simpler like a bar chart.

If you must use it, then I suggest using data labels outside the bubbles so that they point to the bubble.  But rather than showing the number value you show the category/name value of the bubble.  You will get two labels pointing at the same bubble but the reader will understand that there are more than one bubble in that position.
minglelinchAuthor Commented:
Thanks for your comments.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now