Stacked bar chart of baggage fee revenue for top 6 US airlines from 2010-2018

Airline Baggage Fees

While revenue from baggage fees increased by $1.3B among the top 6 US carriers from 2010-2018, most of the additional revenue went to just 3, as shown in this stacked bar chart.  Baggage revenue was close to flat for American, United and Delta--the three largest carriers.  It was up between 24% and 29% per year for the next three--Spirit, Frontier and JetBlue. Data are from the US Department of Transportation, Bureau of Transportation Statistics.

US Top 6 Airline Baggage Fees 2010-2018 in a Stacked Bar Chart with CAGR Column

Stacked bar chart of baggage fee revenue for top 6 US airlines from 2010-2018

How I Made This Stacked Bar Chart with CAGR Column

Data for this chart are presented below: 

Data for stacked bar chart of baggage fee revenue for top 6 US airlines from 2010-2018

The baggage fee data are available for download in Excel on the web.  The data required some manipulation to get it into the form above.  First, data had to be taken from multiple worksheets, one for each year, into a single worksheet.  Next, data for US Airways had to be summed into American for some pre-merger years and the same process was required for Continental and United.  Finally, I added the CAGR data using the Mekko Graphics built-in CAGR formula.

Here's how I made the stacked bar chart:

  • created a chart in PowerPoint from the data range above in Excel
  • used Format Bars and Series to show the last column as a CAGR
  • added the legend and aligned the legend with the CAGR
  • hid the axis lines, labels and tick marks
  • added the y axis label
  • adjusted internal chart margins, y axis maximum and font sizes
  • changed colors of series to highlight Spirit, Frontier and JetBlue and place American, Delta and United in shades of grey

Take This Chart and Make It Your Own

Download this chart and edit it using Mekko Graphics. See more stacked bar charts in our chart gallery. Here are some other charts that may be of interest: