Changes in CO2 Emissions
Emissions were up 1.7% with the largest increases in China, US and India as shown in the top cascade chart. Emissions were down in Europe and slightly up in the rest of the world.
Economic growth was counterbalanced somewhat by energy efficiency and other technology changes, as shown in the bottom chart. The largest reductions were caused by increased energy efficiency, renewables and coal-to-gas switching. Data for these charts came from International Energy Agency, Global Energy & CO2 Status Report.
Changes in CO2 Emissions as Shown in the Two Cascade/Waterfall Charts with Data Row
How I Made These Cascade/Waterfall Charts with Data Row
The data for these charts required some extra analysis and computation to obtain. The IEA report contains 2018 CO2 emissions data for the regions mentioned in the chart and percentage increases in each region for 2017-2018. From these, I backed into 2017 emissions data and the increases in value for each region. I estimated the data for the technology changes, based on a similar cascade chart found in the report and some numerical data found in the report body. Here is how I organized the data in Excel before creating the chart in PowerPoint:
Here's how I made the first cascade chart:
- insert two charts top and bottom from the Insert Multiple Charts button on the Mekko Graphics ribbon in PowerPoint
- open the top chart and change the chart type to cascade
- copy and paste the data from the spreadsheet above into the Mekko Graphics Data Editor
- designate the last bar as a total bar
- change the second series to display as a data row, formatted as a percentage with one decimal place
- use data scaling in Format Chart, Numbers tab to divide the data in the chart by 1,000 converting from megatons to gigatons
- add the axis break
- add the y axis title and hide the axis line, tick marks and values
- right-click on the y axis title and the data row header to turn off autowrap and display both labels on single lines
- adjust internal chart margins
- add segment links
- adjust bar colors
- align the lefts of y axis title and data row header
Here's how I made the second (bottom) cascade chart:
- delete the bottom chart from the slide
- copy the top chart, paste it and move it to the bottom of the slide
- align the bottom chart to the top
- follow a similar set of steps to adjust the formatting of the chart to work with the different data set
Take This Chart and Make It Your Own
Download this chart and edit it using Mekko Graphics. See more cascade charts in our chart gallery. Here are some other charts that may be of interest: