The Pfizer BioNTech COVID-19 vaccine led to strong growth in both revenue and operating income for the company in 2021, as shown in this waterfall chart. Revenue almost doubled from 2020 with 45% coming from the COVID-19 vaccine. Expenses rose, but more slowly than revenue. Hence, operating income increased by 124%. Data are from company website.
Pfizer Operating Income in a Waterfall Chart with Data Row
Why Use a Waterfall Chart for Pfizer Operating Income
This stacked waterfall chart with data row delivers multiple messages. The primary message is in the data row that shows that both revenue and operating income increased significantly. The stacked revenue bar breaks down revenue by product and shows that the Pfizer BioNTech COVID-19 vaccine (Cominraty) accounted for 45% of 2021 revenue. The other bars show the operating expenses and their impact on operating income.
How I Made this Stacked Waterfall Chart with Data Row
Here is the data:
Note that you can create the stacked waterfall in the first column by having multiple rows of data in that column. All other columns have just one row of data.
Here are the steps I used to make the chart:
- create a Waterfall chart in PowerPoint type the data into the Mekko Graphics Data Editor as above
- add formula for Change from FY 2020
- in Format Bars and Series, show the last column as a data column and the last row as a data row, formatted as a percentage
- use Show Labels menu item to show percentages in the first bar only
- in Numbers tab, apply data scaling to divide by 1,000 and format bar totals to be $B and 1 decimal place
- adjust margins, hide 'data column' label, and move data column from right to left of chart to align with the first bar
- add y axis title and hide other elements of y axis and x axis line
- bold select data row labels
- change segment colors