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 showing public holidays and population in select countries
This chart was built using the Aploris add-in with PowerPoint 2016 for Mac.
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.
Mekko chart showing regional and continental populations in 2016
This Mekko chart was built with the Aploris add-in for PowerPoint.
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 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.
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 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.
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 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.
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 by segment
The area chart was built with the Aploris data visualization add-in for PowerPoint.
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 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.
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 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.
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 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.
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 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.