Tag Archives: Food

Scatter plot showing changes in male and female tobacco smoking rates from 2000 to 2015

The scatter chart below shows the change in male and female tobacco smoking rates in different countries between 2000 and 2015. In addition, countries are color-coded by their income levels.

Almost all countries have seen female smoking rates drop – the Russian Federation and the Czech Republic are the two exceptions. Male smoking rates have also dropped in most countries. However, several African and Middle Eastern countries saw a rise.  The shaded green area indicates the part of the chart where both female and male smoking rates dropped.

2x2 scatter plot showing change in smoking rates in different countries

Changes in smoking rates between 2000 and 2015 in various countries depicted in scatter diagram

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

Worldwide cereal production, utilization, and stocks

The combination bar-line chart below shows worldwide cereal production, utilization, and stocks on a yearly basis. In addition, a data row is used to compare the stock levels with the utilization. To clearly show the data, which is spread over a large range, two axes are used. The left axis begins at 1800 million tonnes to amplify the delta between production and utilization.

Production has consistently been higher than utilization which leads to an increase in the available stocks. Further stock levels as a fraction of utilization have also increased slightly.

Bar-line chart showing worldwide cereal production, utilization, and stocks

Cereal production and utilization depicted in a combination bar-line chart

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

Stacked bar-chart showing pure alcohol consumption by type in select countries

The stacked bar chart below shows alcohol consumption by type in select countries among persons aged 15+. The total height in each column is total consumption in liters per capita. The different colored segments in each column correspond to a type of alcohol as indicated in the legend.

Belarus has the highest consumption per capita (age 15+). South Korea’s primarily consumes other spirits. Czech Republic has the highest consumption of beer per capita.

Stacked bar chart showing alcohol consumption in select countries

Pure alcohol consumption by type among persons aged 15+ in select countries

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

Bar-line chart showing coffee consumption in top 20 countries

The combination stacked bar-line chart below showing coffee consumption in the 20 countries with the highest consumption per capita. The bars indicate cups of coffee consumed per day per capita. The line indicates the total coffee consumed in millions of cups. We use a data row to indicate the country population.

While Netherlands consumes almost twice as much coffee per capita as the next highest country, the US’s total consumption is significantly greater than any other country.

Coffee consumption bar-line chart

Bar-line chart showing coffee consumption in top 20 countries by capita

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

Cluster bar chart showing estimated prevalence of diabetes globally

The cluster bar chart below shows the estimated prevalence of diabetes in different global regions in 1980 and 2014. In addition, a data row is used to show the estimated number of people with diabetes. The prevalence rates have increased drastically over the time period.

The data from the World Health Organization’s 2016 Global Report on Diabetes.

Cluster bar chart showing diabetes prevalence

Cluster bar chart showing estimated prevalence of diabetes in 1980 and 2014

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

 

 

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.

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.

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.

Bar chart showing the price of a Big Mac in select countries (Big Mac Index)

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 cost of Big Macs in different countries

Bar chart showing the cost of Big Macs in select countries

The bar chart was built using the Aploris charts add-in for PowerPoint.