100% stacked bar chart and bar mekko chart of air conditioning units and household penetration

Air Conditioning Around the World

The scorching summer in the Northern Hemisphere has left many with a renewed appreciation for air conditioning.  June was the hottest June on record, according to the National Oceanic and Atmospheric Administration (NOAA). Temperatures in France reached all-time highs and other cities in North America, Europe and Asia experienced record heat waves in both June and July. If you have air conditioning, your energy costs soared along with the temperatures. However, you were at least able to mitigate the health risks associated with the heat.

There are 1.6B installed air conditioning units (AC) and 67% of them are in just 3 countries—China, the US and Japan. The current household penetration rate for air conditioning is above 90% in Japan and the US, but it is just 60% in China. It's below 20% in large, hot countries like Mexico, Brazil, Indonesia, South Africa and India.

Forecasters from the International Energy Agency (IEA) are projecting significant increases in air conditioning units due to factors like economic growth, urbanization and population growth. Data from the IEA was published in their Future of Cooling report.

Air Conditioning 100% Stacked Bar and Bar Mekko Charts

100% stacked bar chart and bar mekko chart of air conditioning units and household penetration

 

How I Made the Air Conditioning Units 100% Stacked Bar Chart

Here is the data for in the Mekko Graphics data editor. 

Data sheet for 100% stacked bar chart showing air conditioning installed units by country

Here's how I made the 100% stacked bar chart:

  • Add 2 charts to a PowerPoint slide under Insert Multiple Charts
  • Select the first chart and choose 100% Stacked Bar under Type
  • Copy and paste the IEA data from Excel into the Mekko Graphics Data Editor for the first chart
  • Reduce chart margins to make the chart area wider and longer
  • Under Bars and Series, on the Bars tab, make the last bar a data column, format is to show as percent and remove it from the chart
  • On the Series tab, create an Other series and include all series except China, US and Japan
  • Under Show Labels, choose Show Values and Names, Calculated Percentages Only
  • Convert the data to billions by choosing a data scale value of 3 on the Values tab under Format Chart
  • Add the billions unit (B) to the bar total on the Values tab
  • On the Sort tab, sort the series to show the biggest on the bottom 

How I Made the Air Conditioning Penetration Bar Mekko Chart

Here is the data in the Mekko Graphics Data Editor.

Data sheet for bar mekko chart of household air conditioning penetration by country

Here's how I made the bar mekko chart:

  • Select the chart on the right side of the slide and choose Bar Mekko under Type
  • Copy and paste the IEA data from Excel into the Mekko Graphics Data Editor for the second chart
  • Click on the Switch Bars and Series icon (top right) in the data editor
  • Reduce the chart margins to make the chart area wider and longer
  • Under Bars and Series, on the Bars Options tab, choose the Pop (M) series as the bar width
  • On the Series, Visibility tab, remove the Pop (M) series from the chart but show it as a data row
  • On the Sort tab, sort the bars to show the highest on the left
  • Under Format Chart, General tab, remove the Grand Total from the chart and select Hide All labels
  • Format the bar totals to show as percentages on the Values tab
  • Color each bar to match its color on the first chart by right clicking on the bar and choosing the color from the segment drop down menu. Multi-select by the bars from the Other series (by holding down the Ctrl key and clicking on each bar) and format them at the same time
  • Under Axes, add a Y axis title with a top tick aligned position and hide the line, labels and tick marks
  • Format the axis title font size to be 11 by right clicking on it
  • Nudge the bar total labels and data row labels to improve readability

Take These Charts and Make Them Your Own

Download these charts and edit them using Mekko Graphics. See more bar charts and bar mekko charts in our chart gallery. Here are some other charts that may be of interest: