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.
What do you think?