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.