Select your x axis, y axis, bubble size and set colors to unique. If we use homicides and GDP per capita, do we see a correlation of time. If so, the bubbles should move up and to the right, or down and to the left. Is there a reverse correlation? Do you see any patterns among different countries?
To create, we need the data formatted as so, https://docs.google.com/spreadsheet/ccc?key=0AseK2cPi8K7fdEdRSVJFb1F6MlFTQWRmaFNoVk1Kcnc#gid=0. Important, note how in the spreadsheet with all the data, there’s a space in population. Remove the spaces or Google won’t recognize it as a singe number. Choose three to five countries, and create a chart, then change countries by copy and pasting different data.
Once you have the data, create a Chart -> Trends -> Motion Chart
To export to put on a blog post, click the arrow in the top right of the chart and choose Publish. Can paste that code into any html page or blog post.
One Response to Motion Bubble Visualization