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.
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.
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 when the longest prime numbers were discovered
This chart was built with the Aploris add-in for PowerPoint on a Mac.
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 the relationship between health spending and life expectancy
This chart was built with the Aploris PowerPoint add-in.
The line chart below shows the amazing growth of Bitcoin value over the last year. A delta bridge highlights the 1217% growth!
Line chart showing Bitcoin value over the last year
This line chat was built using Aploris on a Mac with macOS. The delta bridge is a standard feature an can be inserted in a couple of clicks.
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.
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.
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.
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.
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.
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.
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.
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.
The combination bar-line chart below shows worldwide cereal production, utilization, and stocks on a yearly basis. In addition, a data row is used to compare the stock levels with the utilization. To clearly show the data, which is spread over a large range, two axes are used. The left axis begins at 1800 million tonnes to amplify the delta between production and utilization.
Production has consistently been higher than utilization which leads to an increase in the available stocks. Further stock levels as a fraction of utilization have also increased slightly.
Cereal production and utilization depicted in a combination bar-line chart
This chart was built using PowerPoint 2016 for Mac and the Aploris PowerPoint add-in.
The stacked bar chart below shows survey data by country: “Today, which one of the following do you think is the world’s leading economic power?”. Survey conducted by Pew Research Center.
Australia, Canada, and large parts of Europe consider China to be the economic leader while the rest of the world general points to the USA. The percentage point difference between US and China is shown in data column to the right of the chart. Respondents in Japan and South Korea strongly considered the US as the leading economic power while Australian respondents most favored China.
Stacked bar chart showing country-specific survey data on the world’s top economic power
This chart was built using PowerPoint 2016 for Mac and the Aploris add-in.