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
Take This Chart and Make It Your Own
Here are some other posts that may interest you: