# What would be a clear way of showing both the homicide count and rate in one single visualization?

I'm learning to use Google Charts API in order to play around with data from UNODOC statistics. I found this excel file providing information about homicide count and rates from countries in the world in the years 2000-2013. It shows a count of homicide and rate for every country, and I'd like to produce a clear and meaningful visualization comparing the count and the rate of one random country (USA for example), in an insightful way (may be it won't be possible to provide insight, but at least I'd like to compare the percentage with the count without generating confusion).

And one more thing...

One doubt that struck me when looking at the excel table is: how is the percentage calculated? In the U.S.A., the count homicide in 2000 was 15586 per 100000 population, that would make a ~15% percentage, but instead I find a 5.5%. How was that calculated?

I hope that this is the right place to ask such questions!

• In the excel spreadsheet it lists rates per 100,000 population, not percentages. There are more than 100,000 people in the US! A good visual solution is simply a scatterplot. Look up Hans Rosling and Gapminder for a motivating example. – Andy W Oct 14 '15 at 17:16
• aha you're right! It was 5.5 every 100000. I didn't read that well. Thank you – Cris Cole Oct 14 '15 at 17:29
• About the visualization... a scatterplot would display the homicide count, what about the rate? – Cris Cole Oct 14 '15 at 17:32
• You can display the homicide count (or the population estimate) on the X axis and the homicide rate on the Y axis. This will produce a funnel like visualization, see here for an example of homicide rates in US counties. The places with smaller populations will show more variability. – Andy W Oct 14 '15 at 17:37