Category Archives: Marimekko

Mekko chart showing number of wearables models available by location on body and purpose

The Mekko chart below shows the number of wearable models available based on where you wear the device and the purpose it serves. Each column represents the purpose and the width is proportional to the number of models available. Each row represents the location of the body where the device is worn and the height is proportional to its share within the column. In addition, we use a data row to show the average price for the devices by purpose.

3 quick takeaways:

  • Most devices are worn on the wrist
  • Most devices are used for lifestyle or fitness purposes
  • Entertainment devices are primarily worn on the head
Mekko chart of wearables models along with average price

Mekko chart showing number of wearables models available by location on body and purpose

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

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.

Mekko chart showing processing of municipal waste in select countries

The Mekko or Marimekko chart below shows how much municipal waste different countries produce and how they process it. The width of each column is proportional to the total amount of waste produced. Within each column, the segments indicate how the waste is processed.

Germany recycles 65% of their waste and none of it ever goes to a landfill. USA produces the most refuse with over half of it sent to landfills. The data was provided by the Organization for Economic Cooperation and Development (OECD) and Wikipedia.

Mekko chart showing processing of municipal waste

Mekko chart showing generation and processing of municipal waste in select countries

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

Mekko chart showing regional and continental populations in 2016

The Mekko or Marimekko chart below shows global population by continent (columns) and region (rows/segments). The area of each segment is proportional to the population of the corresponding region. In addition, a data row is used to display the CAGR (compounded annual growth rate) for each continent. Antarctica, which does have a small population, is excluded.

Marimekko showing regional and continental populations

Mekko chart showing regional and continental populations in 2016

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

Mekko chart examining some of the largest data breaches

The Mekko chart below shows some of the entities affected by large data breaches. The entities are organized in columns based on their category and the width of the column represents the number of records affected. Each entity is represented by a segment in a column and the area of the segment is proportional to the number of records affected.

Mekko of large data breaches by entity category

Mekko chart of some of the world’s largest data breaches

This chart was built using the Aploris data visualization add-in for PowerPoint. Use Aploris to efficiently build engaging, insightful business charts

Mekko chart showing Michelin star restaurants by country

The Mekko chart below shows the number of Michelin star restaurants organized by country and number of stars. France has the most Michelin star restaurants followed by Japan and Italy. Only 4% (133) of Michelin star restaurants have earned the top rating of 3 stars. Tokyo alone has 217 Michelin star restaurants and has a significant lead on any other city.

Michelin star restaurant mekko

Mekko chart showing Michelin star restaurants by country and rating

Each segment’s area is proportional to number of restaurants that fit in that category. The data row below the chart provides the last update year and the data columns to the right of the chart provide the total number of restaurants by rating.

The Marimekko was built using the Aploris add-in for PowerPoint on a Mac. Data provided by Wikipedia.

Mekko chart of European election votes for right-wing parties

The Mekko or Marimekko chart below shows election vote percentages for right-wing parties in select European countries. The data used is from this NY Times article and Wikipedia.

The width of each column is proportional to the population of the country. The height of the red segments represents the percentage of votes won by right-wing parties in the latest election. As such, the area of the red segments is roughly proportional to the number of people that support right-wing parties. This is subject to election rules and is meant to be indicative of the support for right-wing parties. Some columns have two red segments indicating that there were two right-wing parties. The data row below chart indicates the year of the last election results.

Mekko chart of right-wing votes in Europe

Marimekko of European election results for right-wing parties

This Mekko chart was built using Microsoft PowerPoint with the Aploris add-in on a Mac. You can download the chart here.

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.

Mekko chart showing number of women in select tech companies

The Mekko chart below was built in PowerPoint and shows the number of women working at select tech companies. The width of each column represents the number of employees at the company. The height of the orange/yellow segments indicate the percent that are women and the area of the segments represents the number that are women. eBay has the highest percentage of female employees (tallest) and Microsoft has the largest number of women (largest area).

PowerPoint Mekko chart showing number of women in different tech companies

Mekko or Marimekko chart showing number of women in select tech companies

This Mekko or Marimekko chart was built with PowerPoint using the Aploris add-in.

Mekko chart totaling all the skyscrapers around the world

The Mekko or Marimekko chart below totals all the skyscrapers around the world. The columns are organized by continent and each segment represents a country or region. The area of each segment is proportional to the number of skyscrapers.

China leads with 999 skyscrapers (excluding Hong Kong) followed by the US with 699 skyscrapers.  Hong Kong is is third with 380.  Overall, Asia has 3 times the number of skyscrapers North America has.

Mekko totaling global skyscrapers

Mekko chart totaling global skyscrapers by continent and country/region

This Mekko chart was built with OS X, PowerPoint for Mac, and the Aploris add-in.