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.

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.

What 2,000 Calories Looks Like – NY Times visualization

The stacked bar charts below show what 2000 calories looks like at different popular US restaurants. At Cheesecake Factory and Sonic a single item is over 2000 calories!

Each chart was individually created with a fixed vertical axis to ensure they can be compared across each other. Food and drink are segmented by color.

Stacked chart: What 2000 calories looks like at popular restaurants

Stacked bar charts showing ~2000 calories at popular US restaurants

These charts were built using the Aploris add-in for PowerPoint. Aploris, compatible with Mac and Windows computers, allows users to quickly create insightful business charts including Marimekkos and waterfalls.

Scatter plots exploring relationship between heart rate and lifespan across different mammals

The scatter plots below examine the relationship between a mammal’s resting heart rate and its lifespan. The chart on the left compares heart rate to longevity of life span in years and the chart on the right compares heart rate to total lifetime heart beats. For both charts, log x and y axes are used to help make the relationships clear and to span the large scale. From the left chart we can see that there is an inverse relationship between longevity and heart rate.  However, a visual inspection of the right chart shows that lifetime heartbeats and heart are largely unrelated.

Scatter plots showing relationship between mammal heart rate and lifespan

Scatter plots showing relationship between heart rate and longevity/lifetime heart beats across different mammals

These charts or graphs were built using the Aploris add-in with the latest 64-bit release of PowerPoint for Mac. Aploris is a data visualization add-in for Mac and PC that helps PowerPoint users build better charts.

Bar chart showing number of lines of code for popular technologies

The chart below shows the number lines of code used to build a variety of current and historic technologies. Combining all Internet services Google uses about 33 times as many lines of code as Facebook as indicated by the delta bridge. Given this large delta we use an axis break to help show Google on the same chart as the other technologies.

Bar graph showing lines of code

Bar chart showing number of lines of code for different popular technologies

This chart was built using the Aploris add-in on a Mac with PowerPoint 2016 (64-bit). Aploris offers an improved and efficient way to create charts in PowerPoint. With Aploris you can build spider, Gantt, and Mekko charts in addition to the typical business charts.

Area chart showing number of US craft breweries

The area chart below shows the number of craft breweries in the US by segment between 2008 and 2015. A growth arrow is used to indicate that the overall growth has been 16% CAGR and the data column shows the CAGR for each segment. While all segments have grown, microbreweries have grown the fastest at 27% CAGR.

Area chart showing number of craft breweries in the US

Area chart showing number of craft breweries in the US by segment

The area chart was built with the Aploris data visualization add-in for PowerPoint.

Bar-line chart showing rent economics across major US cities

The bar-line combination chart below highlights the rental economics in several major US cities. The bars indicate the amount of space in square feet you can expect to rent for $1500/month. The line shows the average rent.

Bar-line chart showing amount of space you can rent for $1500

Bar-line chart showing amount of residential space you can rent for $1500 across major US cities

This chart was built using the Aploris add-in for PowerPoint on a Mac. Aploris facilitates the creation of a variety smart business charts in PowerPoint including waterfalls, bar charts, and Mekkos.

Cluster chart comparing the cost of rotisserie and home cooked chicken

The cluster bar chart below compares the cost per pound of rotisserie and home cooked chicken at several American grocery stores. A data row is used to highlight the savings. Except for Costco and Smart & Final, buying a raw chicken and cooking it at home is cheaper than buying a rotisserie chicken. Costco and Smart & Final likely use rotisserie chicken a loss leader, attracting customers to their store.

Cluster bar chart comparing price or chickens at grocery stores

Cluster bar chart comparing cost per pound of rotisserie versus home cooked whole chickens

This chart was built using the Aploris add-in for PowerPoint on Mac with the latest 64-bit Office.

Bar chart showing glycemic properties for select foods

The bar chart below shows the glycemic load (GL) for some common foods. GL measures  the quality (glycemic index) and quantity of a carbohydrate in a meal. In addition, a data row is used to show the glycemic index and serving size. The foods are organized in categories and sorted from highest to lowest GL within each category.

Bar chart showing glycemic load and index for select foods

Bar chart showing glycemic properties for select foods

This chart was built using the Aploris add-in. Aploris integrates with PowerPoint on PCs and Macs to help users quickly make a variety of business charts.

Bubble chart showing relationship between Olympic team size and medals won per athlete

The bubble chart below examines the correlation between the number of athletes that a country sends to the Olympics and the number of medals it wins per athlete. The data averages results from the last 3 summer Olympics Games for the top 20 medal winning countries. The X-axis represents the average team size, the Y-axis shows the average medals per athletes, and the bubble area matches the average medals won.

The data suggests that the more athletes a country sends the more medals they win per athlete. Cuba, an exception, has won more medals per athlete than expected given its average team size. This might be because they try and specialize in specific sports including boxing, athletics, and judo.

Bubble chart highlighting impact of Olympic team size on medal haul per athlete

Bubble chart showing average Olympic team size and medals won per athlete for the last 3 games

This chart was built using the Aploris PowerPoint add-in. Aploris helps business professionals quickly build insightful charts.