Both amount of meat consumption and mix of meat type consumed vary greatly by country with the US consuming over 100 kg per person and India under 4 kg per person, as shown in these bar charts. China's 62 kg per person is 60% pork, while Argentina's 107 kg per person is over 50% beef. Poultry is most popular in the US and India. Mutton and goat is most popular in Nigeria. Meat consumptions data are from the Food and Agriculture Organization of the United Nations (FAO) as reported in Our World of Data.
I used the data from the report to create two charts. The first compares total meat consumption across countries and the second shows the mix differences. The mix analysis chart is also featured in our 10 Strategy Charts guide.
Meat Consumption by Country and Type in a Bar Chart and a 100% Stacked Bar Chart
How I Made Meat Consumption Bar Chart and 100% Stacked Bar Chart
Data for both of these charts are presented below:
Our World of Data provided meat consumption data by country, region and file for download. I took that csv data and created an Excel PivotTable. From the PivotTable, I generated the above spreadsheet data. I wanted to choose a representative set of larger countries that varied both in amount and type of meat consumed.
Here's how I made the charts:
- created the 100% stacked bar chart first
- shrink height of chart container so chart fills 1/2 page
- used the switch bars/series button to treat rows as bars and columns as series
- selected the subset of bars (countries) from my spreadsheet, eliminating the ones I did not want to use in Format Bars and Series
- showed legend and placed on bottom of chart
- hid bar totals and showed percentages in segment labels
- adjusted internal chart margins to make chart fill container
- added segment links
- his segment labels in very small segments to increase readability
- used custom sort to order series, bars and legend items
- added y axis title
- hid y axis lines, labels and tick marks and x axis line
- moved y axis title to bottom of chart and bar labels to show above bars
- adjusted series colors
- copied 100% stacked bar chart and used copy as basis for top bar chart
- changed chart type to stacked bar
- hid all series, except total meat consumption by country and hid last bar that showed world
- added average line for world average
- added bar gap after last bar so that the bars of both charts aligned
- hid segment labels and bar labels
- showed bar totals with kg as suffix
- updated y axis title and series color
- aligned the two charts and positioned the bar above the 100% stacked.