While individuals receive the largest share of the CARES Act stimulus package, loans to large companies is the largest segment at $425B or 21% of the total, as shown in this Marimekko chart. The bulk of CARES Act relief to individuals will come in cash payments ($300B) and extra unemployment benefits ($260B). Other large amounts are for new small business loans ($350B) and aid to state and local governments ($340B). The Coronavirus Aid, Relief, and Economic Security act was passed in response to the COVID-19 pandemic. Data for this chart came from Visual Capitalist.
CARES Act Stimulus Bill Spending in a Marimekko Chart
How I Made this CARES Act Stimulus Spending Marimekko Chart
Here is the CARES Act data I used to create the Marimekko chart:
Since each bar has a unique set of segments, the data are on a diagonal in the Mekko Graphics Data Editor with only one entry for each row in its proper column.
Here's how I made the CARES Act Marimekko chart:
- add a Marimekko chart to the PowerPoint slide and type the data from Visual Capitalist as above
- hide the grand total, y axis, and x axis line
- adjust the internal chart margins to have the chart fill the entire width of the PowerPoint container
- in the Values tab of Format Chart, select grand total in the Calculated Percentage section to make segment percentages calculated with respect to the chart total and not the bar totals
- format segment values and bar totals as $B
- display the series name, segment value and calculated percentage in each segment and the bar total and calculated percentage at the top of each bar
- reduce label sizes in smaller segments and annotate the two smallest segments
- adjust colors in each segment to make each bar shades of a different color