Airline passenger traffic will grow most quickly in some key Asian markets over the next 20 years. Traffic growth within South Asia is estimated to be 9.5% per year and within Southeast Asia 7.5%. Growth within North America, within Europe and between North America and Europe is estimated to range between 2.6 and 3.2% per year. These changes will cause major shifts in where airplanes are purchased, airports built and expanded, and in airline routes. The data for the top 10 regional flows, based on data from Boeing's 2016 Current Market Outlook, are summarized in the bar mekko chart below:
The data were copied from a table in the Boeing report into Word. I used the convert text to table function to create a data table that I then copied and paste into Excel. I used the data from the Excel table for 2035 RPK by region and RPK growth to create the bar mekko chart. After trying different numbers of regions and including and removing a 'rest of the world' bar, I chose to show the top 1o flows. These best supported the message that traffic growth would be highest in Asia and lowest in Europe and North America.
I used the annual growth as the bar height in the bar mekko and the 2035 rpk as the bar width. I also included the 2035 rpk data as a data row at the bottom of the chart. I reduced all label size to 8 point and eliminated the x and y axis to improved readability and the look of the chart. I used the color by bars option to make each bar a different color.
I added to lines to the chart using the average line feature in Mekko Graphics. These lines can be adjusted to be target lines or to show relevant statistics. In this case, I showed the average growth to highlight the above and below average flows. I also added GDP growth to show that airline passenger flow is estimated to grow much faster than GDP over the next 20 years.
Here is the data in SlideShare to download and edit using Mekko Graphics: