Billionaires and Their Wealth

There were 5% fewer billionaires and total billionaire wealth declined 7% from 2017 to 2018, as shown in these stacked bar charts. The decline in the number of billionaires was greatest in Asia, shrinking from 784 to 677 (14%) and their total wealth went from $2.4T to $2.2T (9%). The number of billionaires went from 821 to 792 in Europe (4%) and their wealth went from $2.3T to $2.2T (7%). In North America, the number of billionaires increased from 727 to 750 (3%), but the total wealth of North American billionaires declined 5% from $3.3T to $3.1T. Data are from the WealthX Billionaire Census 2019.

Number of Billionaires and Billionaire Wealth in 2018 and 2019 in Stacked Bar Charts with Data Column to Show Percent Change

How I Made these Stacked Bar Charts with Data Columns

The data for these charts are presented below:

Here's how I made the stacked bar chart with data column on the left:

create a 1/2 page left chart in PowerPoint (stacked bar by default)
type in data to Mekko Graphics Data Editor from WealthX Billionaire Census 2019
create Rest of World row by adding data for smaller regions
add formula for percentage change in column D
in Bars and Series dialog, designate column D as a CAGR column, hide rows for smaller regions and apply custom sort to series so that they display in order of 2019 data with largest on bottom
add legend and align with CAGR
hide axis lines, tick marks and labels by right-clicking on each axis
add y axis title
adjust internal margins and bar gaps
add segment links and bar comparison lines
show values and calculated percentage in segment labels
change colors of series