Skip to Content

I have an Excel file of sales data and wanted to see how it looks on a Bubble Chart.  I need at least two measures, at least according to Wikipedia.

1figure.PNG

In the above I show sales, profit and use sales to show the Bubble Width.  Category of sales is used as a data legend for the color.

/wp-content/uploads/2014/03/2showdatalabelsa_400553.png

I can show the the data labels as shown above and below:

3toobusy.PNG

But to be honest, it is too busy to have the numbers on the bubbles (my take).  I’d rather have the category names on the bubbles but I couldn’t figure out how to do that.  If I have time I will submit that to Idea Place.

4cloud.PNG

It does look nice when I publish to the Lumira Cloud as shown above.

4abubble.PNG

If I add profit to the bubble height it looks strange to me as well.

Just for fun, I did a tag cloud in Lumira, but that really doesn’t suit here:

tagcloud.PNG

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Jansi Rani Murugesan

    Hi Tammy,

    From my understanding, Since the legend ( in your above example “category” ) already shown on the right side, might not look good, if it is shown again as DATA label.

    so fine with Sales in data label and category in colors, would be more meaningful.

    and regarding bubble height/ width you can also get the co relation and ratio between sales and profit. If sales ( width of the bubble) increases and how the profit ( height of the bubble) reacts?

    But we always use bubble chart to get the ratio of 4 different measures. (in x,y axises, bubble width and colour), So your case, don’t use the measure sales in bubble width again, you can either use location or other measures,  it should be 4 different measures, then your chart would be more meaningful.

    For instance, I would like to show my recent analysis on our SITSG2014 participants list,

    I just want to see how many of them from each company with different designation participated.

    from down IBM( color), 13 people (axis) with 7 different designation participated.

    t1.JPG

    Thanks

    Jansi

    (0) 
    1. Tammy Powlas Post author

      Hi Jansi,

      Thank you for reading and commenting.

      Yes, I agree, you can tell by the legend, but it is not so easy for the consumer of the bubble chart to keep scrolling on the right to look at the legend’s color.

      I tried many things but this was the best I could come up with because I wanted to look at profit and sales.

      I can get the data value figures on the bubble, why not the names itself? 

      I haven’t submitted to Idea Place yet as I have other things submitted there now.

      (0) 

Leave a Reply