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
How I Made the Air Conditioning Units 100% Stacked Bar Chart
Here is the data for in the Mekko Graphics data editor.
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.
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