Linear bubble charts for comparison

A colleague of mine uses a lot of bubble charts and wanted a simpler way to compare the data in each chart.   I have to say I am not a big fan of bubble charts as I find them difficult to analyse and compare, however I accepted the challenge!  This is what I proposed:

The chart is actually quite simple and I’ve uploaded it here if you wish to see how it was done.  Each line is set up on a different tab, (data1, data2, etc) but in essence, each line of bubbles in the chart has a different number in the Y axis column.  For the first line, the value is 22, for the second line, the value is 17 and so on until the last line which has a value of 2.  The value column gives the size of the bubble and the date column is uniform to allow the positioning of the centre of each bubble.

excel data

What do you think?

+Alesandra Blakeston

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s