Category Archives: Bar-mekko

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.

Bar-mekko chart showing top 10 countries with the highest GDP per capita

The bar-mekko chart below shows GDP per capita and population in the 10 countries with the highest GDP per capita. The height of each segment is proportional to GDP per capita and the width is proportional to the population. As a result, the area of each segment is proportional to the total GDP.

Bar-mekko with GDP per capita and population

Bar-mekko chart showing GDP per capita along with population in top 10 countries

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

Bar-mekko chart of public holidays and population in select countries

The bar-mekko chart below shows the number of public holidays (height) and population (width) of select countries around the globe. The area of each segment is proportional to the total number of ‘human-holidays’ each country provides. Colombia and India have the highest number of public holidays per person but India leads the number of human-holidays due to its large population.

Bar-mekko chart showing public holidays in select countries around the world

Bar-mekko showing public holidays and population in select countries

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

Growth of Asian billion dollar startups

The bar chart (A) below shows that billion dollar startups have grown at 81% compound annual growth rate (CAGR) over the last 2 years lead by those in Asia. Asian startups have outpaced other regions growing at 126% CAGR. Across regions both the number of billion dollar startups and the average valuation has increased. Note that foreign exchange rates can also have an impact on valuations. For example, the Euro has become significantly weaker compared to the US dollar over the last two years.

Funding for billion dollar startups

Bar chart showing total valuation of billion dollar startups by region

The Mekko chart (B) below provides an overview of the Asian startups by industry. The area of each square is proportional to the valuation of the startup it represents.

Mekko of Asian startups

Mekko chart of the Asian startup landscape by industry

Asian startups are largely focused on E-commerce and Hardware, which make up a larger portion of the total landscape than in other regions. E-commerce and Hardware comprise 60% of the total value of Asian billion dollar startups. Surprisingly, there is only one billion dollar startup, InMobi, in the Software industry. In other regions, Software is 26% of the total value but in Asia it only makes up 2%. However, these ratios are subject to significant fluctuation as startups are funded, experience growth, and potentially exit (e.g. go public, get acquired).

download pptfree trial

 

 

 

The stacked bar chart (C) below shows funding in these startups over the last 2 years. Overall funding has grown at 88% CAGR with the average funding per startup also increasing. Funding in Asian startups is growing significantly faster (128%) than the US (70%) but lagging the smaller Europe (162%).

Funding for billion dollar startups

Bar chart showing funding for billion dollar startups by region

The bar-mekko (D) below shows valuation-to-funding ratio (height of segment) and the total funding (width of segment). As such, the area of each segment is proportional to total value of all the startups in the region. US and Asian startups have similar valuation-to-funding ratios.

Valuation-to-funding ratio

Bar-mekko showing valuation-to-funding ratio by region

download pptfree trial

 

 

These charts were built with the Aploris PowerPoint add-in. Source data for these charts from the WSJ.

Global greenhouse gas emissions plotted in bar-mekko

The bar-mekko chart below is a variant of the Marimekko chart. It shows global greenhouse gas emissions by continents.

Each region’s population is displayed by the width of each column. The population of a continent is therefore proportional to its range on the x axis. The column labels also include the population data. The height of each column in a column shows the amount of emitted greenhouse gases per capita. With this data representation the area of each segment is proportional to the total amount of a continent’s greenhouse gas emissions.

Colored segments are used to differentiate between different types of greenhouse gases. Because some the of segments were small, a legend is used. For cleanliness, the labels for smaller segments were excluded.

Bar-mekko chart showing global greenhouse emissions

Bar-mekko chart showing global greenhouse emissions per capita and by type

This Mekko chart was built with PowerPoint 2016 on OS X using the latest Aploris for Mac release.

Bar mekko chart showing greenhouse gas emissions for 5 largest US states

The mekko chart, or specifically the bar-mekko chart, below shows greenhouse gas emissions for the 5 largest US states.

The width of each column is proportional the state’s population.  The column labels also include the population data.  The height of each segment in a column represents metric tons per capita emitted for each type of greenhouse gas.  Because some the of segments were small, a legend is used.  For cleanliness, the labels for smaller segments were excluded.  In addition, this mekko chart has visible x and y axes.

Bar-mekko chart showing greenhouse emissions

Bar-mekko chart showing greenhouse emissions per capita and by type for the 5 largest US states

This mekko chart was built using Aploris on a Mac with PowerPoint 2016.

Bar-mekko showing Internet penetration in different geographies

The bar-mekko chart below efficiently shows Internet penetration in different geographies around the world. The height of each segment is the penetration percentage; the width is the size of the population.  Therefore, the area of each segment allows the reader to quickly compare the number of active internet users in different geographies.

The bar-mekko is similar to the Marimekko or mekko chart except it has a variable height. It is also effective when used to compare profitability of value chains and business segments.

Bar-mekko chart examining global Internet penetration

Bar-mekko chart examining global Internet penetration

Bar-mekko showing estimated labor surplus or shortage by country in 2030

The bar-mekko chart below shows the estimated labor surplus or shortage by country in 2030. The x-axis, or the width of the bars, depicts the size of the labor force and the y-axis, or the height of the bars, shows the percent labor surplus/shortage. Therefore, the area of the bar indicates the absolute surplus or shortage. However, for Germany and Brazil we use the axis break to make the chart more readable. As such, the area of the respective bars is not the true representation of the absolute surplus/shortage.

This data was published by BCG and Business Insider based on work led by BCG partner Rainer Strack.

Bar mekko showing labor supply and shortage/surplus in 2030

Bar mekko showing labor supply and shortage/surplus in 2030

How will we solve the potential labor shortage in 2030; analysis by @BCG #dataviz #consulting #powerpoint #mac

Bar-mekko with California car travel and delays

This chart shows the amount of car travel in three metropolitan areas of California. A variable-width column chart is used to depict the interplay of two factors. Along the x-axis the existing roads are plotted in terms of lane miles. This means that for instance a 100 miles of three-line a highway add 300 lane miles. The y-axis shows how often each lane mile is traveled per day.

The product of lane miles and travel per line equals the amount if daily travel miles. If each lane of said highway section is passed by 15,000 cars per day, 4.5 million travel miles are added to the total. With variable-width chart this relationship is made clear as the width and height form the area of each element.

A line of additional data below the plotting area shows the average delay per lane mile in each area. Unsurprisingly, in densely populated areas more intensely used roads lead to higher delays.

With Aploris Charts this value is part of the chart data and can be the result from a calculation based on other chart data. This means that values and positions are automatically updated if any of the input values changes.

This type of chart is also known as a bar-mekko or skyline chart. It can be viewed as a variant of a Marimekko chart or a cross between Marimekko and column chart. In a simple application like here only one series of data is displayed while more complex application may also stack multiple series.

Car travel intensity for metropolitan areas in California

Car travel intensity for metropolitan areas in California