Bar chart showing top 10 countries by internet speed

The bar chart below shows the top countries by average internet speed in Q4 of 2015. South Korea holds a significant advantage, almost 8Mpbs faster than second place Sweden. Data rows are used to show the percent of requests that were above 10 and 15Mbps. Includes business and residential connection speeds but excludes mobile connections.

PowerPoint bar chart illustrating countries with fastest internet connections

Bar chart showing top 10 countries by internet speed (Q4 2015 Mbps)

This chart was built with the Aploris add-in for PowerPoint.

2018 Winter Olympic medals normalized by team size

The bar-mekko chart below shows the number of Olympic medals won normalized by the team size. The width of each column represents the size of the team representing the country and height represents the medals they won per team member. As such, the area of the represents the number of medals won. 3 segments are used to separate out gold, silver, and bronze medals.

Visualizations of Olympic results typically show the total number of medals won by each country. However, each country sends different number of athletes based on a number of factors including qualifications. Showing the number of medals won normalized to team size would highlight the strengths of different teams.

The Netherlands won a shocking 0.61 medals per athlete they sent. Almost twice as much as the next closest country, Norway, which one the most medals. The Netherlands dominates speed skating which represents all the medals they won.

2018 Winter Olympic medals variable width bar chart

Bar-mekko chart showing 2018 Winter Olympic medals normalized by team size

This chart was built with PowerPoint 2016 for Mac and the Aploris add-in.

When the longest prime numbers were discovered

The line chart below shows when the longest prime numbers were discovered. Because the lengths vary greatly, a log axis is used.

The longest known prime number was discovered on Dec 26th, 2017 with a length of 23,249,425 digits, nearly 1 million digits longer than the previous record. The accelerated discovery of prime numbers is largely due to computing power and distribute computing projects like GIMPS.

Line chart showing longest prime numbers and when they were discovered

Line chart showing when the longest prime numbers were discovered

This chart was built with the Aploris add-in for PowerPoint on a Mac.

Link between health spending and life expectancy

The scatter chart below shows the relationship between life expectancy and health expenditure for a variety of countries. The x-axis shows life expectancy at birth and the y-axis shows healthcare spend per capita for each year of life expectancy (in 2010 international dollars). Countries are color coded based on their region.

In general, the more countries spend on healthcare the longer their citizens live.  However, the US is a significant outlier. The US spends much more than any other country but its life expectancy is below many. The source article (https://ourworldindata.org/the-link-between-life-expectancy-and-health-spending-us-focus) plots health expenditure per capita on the y-axis (instead of healthcare spend per capita for each year of life expectancy). However, we find that their visualization is not as effective in calling out the US as an outlier.

Scatter plot showing healthcare spending/life expectancy

Scatter plot showing the relationship between health spending and life expectancy

This chart was built with the Aploris PowerPoint add-in.

Survey of US adults and their use of social media to get news

The Mariekko chart below shows how many sites social US news users get news from. Each column represents a social site and the rows indicate the percentage for their US users that get news from just that site, 2 sites (that plus another), or 3 or more sites. The width of each column represents the percentage of social news users that use that site.

Facebook has the largest number of social news users and 50% of them only rely on Facebook for news.

Marimekko with US users social site news consumption

Mekko chart showing how many sites social news users get news from

This chart was built with the Aploris chart creator add-in on PowerPoint for Mac.

Comparing the length of top metro systems globally

The bar chart below compares the length, measured in kilometers, of the top 15 metro systems globally. In addition, the yearly ridership and number of stations are listed in data rows below the chart.

China has a clear lead with 6 cities in the top 15! In addition, Shanghai and Beijing have significantly longer systems than any others.

Length of metro systems shown in bar chart

Bar chart comparing the length, ridership and number of stations in the top 15 metro systems globally

This chart was built with the Aploris add-in on PowerPoint for Mac 2016.

Comparing iPhone models for talk time, screen size, and songs held

The filled spider chart below compares all primary iPhone models for talk time, screen size, and songs held. Each variable is mapped to an axis creating a 3 axis chart. Therefore, each iPhone is represented by a triangle and the triangle corners map to the phone’s capabilities for the selected variable.

As expected, newer models have greater capabilities and as a result the triangle that represents them is larger than the previous model. Over the years, iPhone screen size has not changed as much as battery life (talk time) and storage (songs held). For the selected variables, iPhones 7 and 8 have the same capabilities.

iPhone comparison: talk time, screen size, and songs held

Spider chart comparing primary iPhone models for talk time, screen size, and songs held

This chart was built with the Aploris add-in for PowerPoint.

Area chart showing movie distributor/studio market share

The area chart below shows the top 5 movie distributors’ market share over the last 5 years. The total height for each year indicates the total gross sales and the relative height of each segment represents the distributor’s market share (among the top 5). In addition, the top performing movie is listed below the chart in a data row.

Buena Vista has steadily grown over the last 5 years and took the lead in 2016 with Rogue One. The other distributors have often interchanged market share rankings.

Top 5 movie distributor market share from 2012 to 2016

Area chart of top 5 movie distributor market share from 2012 to 2016

This chart was built using the Aploris add-in for PowerPoint on a Mac.