Edible Insect Market Growth

The edible insect market is projected to grow about 24% per year over the next 5 years as shown in this stacked bar chart. The growth will be strongest in North America and Europe, according to data from Meticulous Research reported by Bloomberg. The worldwide market will grow from about $400M in 2018 to almost $1.2B in 2023. Asia-Pacific and Latin America account for over 50% of the market.

Farming edible insects has less of an impact on the environment than farming other animal proteins. The cluster bar chart compares the amount of feed, land and water required to produce an equivalent amount of insect, chicken, pig and beef either by weight or by amount of protein. Insects require the least, followed by chicken, pig and cow for feed, land and water usage. Cows require at least 5 times more feed, land and water than insects.

Stacked and Cluster Bar Charts

How I Created these Bar Charts

There are 4 Mekko Graphics charts on this slide. The stacked bar with the CAGR column is a single chart. The cluster bar is composed of three Mekko Graphics charts. I used three charts so that each cluster will be appropriately scaled.

Here are the steps I took to create the stacked bar chart:

enter the data for 2018 and 2023 for each region
use the Mekko Graphics CAGR formula to calculate the CAGR column
set the column as a CAGR and add the CAGR total, entering its label as 24%
adjust margins, hide the y axis and add the legend
adjust colors for the series

Here are the steps I took to make the cluster bar charts:

copy the stacked bar so that the chart size and x axis are the same
convert to cluster bar and input the data for each species and each environmental impact category
hide the land and feed clusters
shrink the chart width to about 1/3 size
hide y axis and adjust colors
close and copy the chart, showing the land cluster
adjust the y axis maximum so that the tops of the largest bars align between the two charts
repeat for water cluster
open feed cluster, add legend and y axis title
adjust width of this chart and right margin so that the bars look the same across all three charts and align