The bar chart below shows the price of a Big Mac in the 6 most expensive and the 6 cheapest countries. Published by The Economist, this ’Big Mac Index’ is a fun way of comparing purchasing power parity. Although, there are several limitations in the comparison as the Big Mac varies in weight and nutritional content across countries. In India, for example, McDonald’s doesn’t serve beef and the Chicken Maharaja Mac is used instead.
Bar chart showing the cost of Big Macs in select countries
The bar chart was built using the Aploris charts add-in for PowerPoint.
The scatter chart below shows the relationship between a country’s concern for climate change and the amount of CO2 it emits per capita. The original source zooms in and limits the y-axis between 8 and 12 on the climate change concern index. As result, it visually suggests a relatively strong correlation that high CO2 emitting countries are less concerned with climate change. Displaying the entire working range of the y-axis still suggests this correlation but it is less visually strong (note that lowest value concern index possible is 3).
Scatter plot showing correlation between a country’s climate change concern and CO2 emissions
The scatter chart was built using with PowerPoint using the Aploris charts add-in. Data provided by Pew Research Center.
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.
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 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).
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%).
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.
Bar-mekko showing valuation-to-funding ratio by region
These charts were built with the Aploris PowerPoint add-in. Source data for these charts from the WSJ.
The bar chart below show the happiness scores for select countries along with the 95% confidence interval. In addition, a data row is used to highlight the country’s overall ranking. For each country the segments in the stack show how the scores can explained by various factors. For examples 1.0 of the United States’ 7.1 score can be explained by social support.
Denmark leads the world with an overall score of 7.5 driven by GDP per capita and social support.
Stacked bar chart with confidence intervals showing happiness scores for select countries
This bar chart, including the data row and error indicators, was built with the Aploris add-in for PowerPoint on a Mac.
The bubble chart below shows the number of people without access to improved water in select countries. The area of the bubble is proportional to the number of affected people. The x-axis is used to indicate what percent of the population this represents and the y-axis is the 2014 GDP. Note that the y-axis uses a log axis to effectively show the broad range of GDPs.
As you might expect, there seems to be a correlation between the country’s GDP and its ability to provide improved water to its residents.
Bubble chart showing number of people without access to improved water, percent of population affected, and GDP for select countries
This bubble chart was built using the Aploris add-in on an Apple MacBook Pro running Office for Mac. The bubble sizes, axes properties, and legend are all easily controlled with the Aploris add-in.
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 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.
The Mekko chart below shows use of fresh water across several countries per year. The width of each column indicates the amount of water used by a specific country and the height indicates the share used by a sector. The area of each segment is proportional to the water used by the corresponding sector and country. Most of the fresh water is used from agricultural needs and India uses the largest amount.
Mekko chart showing fresh water use by country
This Marimekko chart was built with Aploris for Mac and Office for Mac 2016.
The Mekko chart below compares the daily caloric consumption across different countries and food types. Each column represents a country (or the worldwide average) and the width of the column is proportional to the average consumption per capita in that country. Each column is then split in segments that represent the different food categories/types. The height of each segment is proportional to calories represented by each segment.
The US has the highest level of consumption at 3641 calories per day driven by sugar and fats. Across the world, grains are the primary source of calories comprising 45% of our diet. India, largely vegetarian, only gets 1% of its calories from meat.
Mekko chart comparing caloric consumption by country and food category
This Mekko or Marimekko chart was built with the Aploris add-in on a Mac running PowerPoint 2016.
The Mekko or Marimekko chart below explains the purpose and operating country for all the man-made satellites orbiting earth. Columns are organized by operating country and the width is proportional to the number of satellites. Rows are organized by purpose and the height is proportional to the share of the purpose. As such, the segment areas represent the number of satellites operated by a specific country for a specific purpose.
The US operates the majority of satellites (largest width) and globally the most common purpose is communications (largest heights).
Mekko chart showing number satellites by operating country and purpose
This Marimekko chart was built using a Mac and Office 2016 with the Aploris add-in.
The bar charts below explain US News’ 2016 ranking of Germany as the best country in the world. The chart on the left provides the normalized overall score for Germany and a few sample countries. The chart on the right looks at the each of the components that comprise the overall score for Germany.
The data row (row of numbers below the chart) show how Germany and the other countries rank for each of the scores. Germany is ranked first for entrepreneurship.
Two bar charts explaining US news ranking of Germany as best country
These charts were built on a Mac with Aploris and PowerPoint 2016.