While the most COVID-19 cases to date have been reported in the US, European countries have the highest ratio of cases per capita, as shown in these two horizontal bar charts. Data are from Johns Hopkins Coronavirus COVID-19 Global Cases report and are as of April 9. Reported cases and cases per capita are functions of both the number of infected people and the degree to which each country is testing for the novel coronavirus.
The US had 432,438 reported COVID-19 cases, which is far more than Spain, Italy and Germany which have over 100,000 each. Another 7 European countries, China, Iran, Canada, Brazil, and South Korea have 10,000 or more reported cases.
Spain has 3,170 COVID-19 cases per million inhabitants. Switzerland, Italy and Belgium each have over 2,000 cases per million. Austria, Germany, US, Portugal, France and the Netherlands all have between 1,000 and 2,000 COVID-19 cases per million.
COVID-19 Cases by Country in Total and per Million Inhabitants in Two Horizontal Bar Charts
How I Made These COVID-19 Cases by Country Horizontal Bar Charts
The COVID-19 by country data used for both of these charts are presented below:
Here's how I made the horizontal bar chart on the left:
- scrape the COVID-19 cases data from Johns Hopkins and worldometers websites into Excel
- use a formula to compute Cases per million
- create a horizontal stacked bar chart in PowerPoint from the Excel data range above
- adjust the chart size to be a 1/2 page chart and place it on the left hand side of the slide
- use Switch Bars and Series button in Edit Chart ribbon to treat rows as bars
- using Bars and Series form, show data from column B only, choose bar colors to indicate region as shown in legend above and set sort order to tallest on top
- hide the x axis line, y axis line, and tick marks and enter the y axis title
- hide segment labels
- adjust internal chart margins
Here's how I made the horizontal bar chart on the right:
- copy the left chart
- use Bars and Series to show data in column D only on chart
- change the y axis title
I added the legend using text boxes in PowerPoint and used the Standard Colors button in the Mekko Graphics Tools ribbon to set the legend colors to be the same as the corresponding chart colors.