Tag Archives: Food

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.

Stacked bar chart comparing calories in a signature burger and fries at different fast-food restaurants

The stacked bar chart below shows the calories in a signature burger and medium fries at common fast-food restaurants. In addition, the data rows show the fat and sodium content for the total meal.

In-N-Out’s double-double and medium fries has the most calories at total of 1,065. The In-N-Out meal also has the most fat and sodium. As a next step, normalizing the calories to the size of the meals might provide additional insights.

Stacked bar chart comparing calories for signature burgers and medium fries at fast-food restaurants

Stacked bar chart comparing calories for signature burgers and medium fries at fast-food restaurants

This chart was built with Microsoft’s PowerPoint and the Aploris add-in on a Mac running OS X. The data rows are a part of the chart and can be configured automatically with Aploris.

Bubble chart examining access to improved water in select countries around the globe

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

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.

How the time we spend cooking has changed

Over the last 50 years, significant advances in food technology and the rise of food corporations have undoubtedly had an impact on how we eat. Work by the NIH, recently brought to our attention by food writer Michael Pollan, has highlighted how the time we spend cooking has also changed.

The cluster chart below outlines the average time US adults have spent cooking between 1965 and 2008. The bars indicate the minutes per day spent by men and women who cook, while the data row specifies the percentage of men and women who cook. In general, fewer women cook and spend less time cooking in 2007-08 compared to 1965-66; conversely, more men cook and spend more time cooking in 2007-08 compared to 1965-66.

In 1965-66, women spent an average of 104 minutes per day cooking meals while men spent only 10 minutes.  As more women started also working outside the home, their cooking time dropped to 44 min per day in 2007-08. Men, however, have not completely balanced out this shift, as their average time spent cooking has only increased to 19 min per day in 2007-2008. As a result, the average time spent cooking per day has dropped from 114 minutes to 63 minutes.

 

Cluster chart showing changes in time we spend cooking

Cluster chart examining how the time US adults spend cooking has changed

The cluster chart above was built in PowerPoint using the Aploris plug-in/add-in.

Since US adults have increased caloric consumption over the last 50 years, this data would indicate that US adults are either consuming more food outside the home or are relying on packaged food to offset the reduced time spent cooking. Such changes have likely had a significant impact on the nutritional quality of the food we eat.


At Aploris we build productivity tools for PowerPoint users.  Our data visualization add-in helps users create a variety of charts including Mekkos, waterfalls and Gantts.  Our new product, TeamSlide, is a slide management solution embedded in PowerPoint that helps users better access their team’s shared content (slides, visuals, charts, etc.).

Mekko chart highlighting fresh water use across different countries

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.

Marimekko chart showing water use in different countries

Mekko chart showing fresh water use by country

This Marimekko chart was built with Aploris for Mac and Office for Mac 2016.

Mekko comparing caloric consumption across countries and food categories

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.

Marimekko comparing caloric consumption

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.

Stacked bar chart examining saturated fat in common oils and fats

The 100% stacked bar chart below looks at the percent of saturated fat found in commonly used oils and fats. Each bar shows all the fat components but only labels for the saturated fat components are visible. Note that butter and margarine include some non-fat components (e.g. water, protein). Unrefined coconut oil has the highest proportion of saturated fat versus other fats.

Stacked bar shart examining saturated fat

Examining saturated fat in commonly used oils and fats with a 100% stacked bar chart

This stacked bar chart was built using the Aploris add-in for PowerPoint 2016 (Mac).

Marimekko chart showing average daily caloric intake for Americans

The Mekko chart below (or Marimekko) explains the average daily American caloric intake. The size of each square in the chart is proportional to number of calories it represents.  Therefore you can quickly get a sense on what the largest contributors are: added fats & oils, wheat flour, and red meat. Surprisingly, vegetables only comprise 125 daily calories.

How does your diet compare?

Mekko chart showing daily caloric intake

Mekko chart showing average daily caloric consumption for Americans in 2010

This chart was built using Aploris and PowerPoint for Mac.

Mekko chart showing US cheese production

The Mekko or Marimekko chart below shows US cheese production by type in 2014. The cheese types are divided into three categories that are arranged in columns (Italian, American, Other). Each segment represents a different type of cheese and the area of each segment is proportional to the amount produced.

Mozzarella and cheddar are the most common cheeses produced in the US by a significant margin.

Mekko chart of US cheese production

Mekko chart showing US cheese production by type in 2014

This Marimekko (Mekko) chart was created using Aploris on Mac with Office 2016.

 

Waterfall chart showing change from 2004-2012 in daily caloric intake for US children

The waterfall or cascade chart below shows the primary components that have changed in American children’s diets between 2004 and 2012.

The baseline indicates the average caloric intake in 2004. Each bar shows the increase or decrease relative to this value across food categories. The actual value is not of primary relevance and therefore not displayed. Adding up the change values results in the total change mathematically as well as visually using this type of chart.

Components of change in daily caloric intake for US children between 2004 and 2012 displayed in a cascace chart

Components of change in daily caloric intake for US children between 2004 and 2012

This waterfall chart is rotated allowing the audience to easily read the labels. The width of each bar is proportional allowing readers to quickly discern that the change in calories is large due to a drop in consumption of sugar-sweetened beverages. In addition, we have used a highlight color to further draw the reader’s attention to this finding.