Home/mobile consumers account for most of the growth in the $101B entertainment market, as shown in the top stacked bar chart. Theatrical viewers went from 52% to just 42% of the global entertainment viewers and grew at 2% between 2015 and 2019. Over the same time period, the home/mobile market grew at 13% and the overall market grew at 8% per year.
Digital has replaced physical distribution for home/mobile viewers, as shown in the bottom stacked bar chart. Digital grew 31% per year and went from 46% to 83% of home/mobile entertainment dollars spent. Over the same time period, physical sales (e.g., DVDs) decreased at 15% per year, falling from $20B to just $10B. Data are from the Motion Picture Association 2019 Theme Report.
Global Entertainment Market in 2015-2019 in Two Stacked Bar Charts with Growth Line and CAGR Column
How I Made these Global Entertainment Market Stacked Bar Charts:
The entertainment market data used for both charts are presented below:
Here's how I made the top stacked bar chart:
- use "Insert Multiple Charts" on the Mekko Graphics ribbon in PowerPoint to create "Two Charts Top/Bottom"
- open the top chart and enter the data for 2015-2019 theatrical, physical and digital from the Motion Picture Association 2019 Theme Report page 8
- use a sum formula to create the home/mobile row and the CAGR formula to create the CAGR column
- with the right-click in cells A2 and A3 do not display these series in this top chart
- similarly, right-click in G1 to display this column as a CAGR column
- add the y axis title and hide the other y axis elements and the x axis line
- show the legend and align it with the CAGR column
- adjust internal chart margins and make bar gaps wider
- add growth line with display set to CAGR without parentheses and adjust y axis maximum
- update the series colors
Close and copy this chart. Delete the bottom chart and put this copied chart in its place. Change the rows displayed as series in the bottom chart to show physical and digital, adjust colors and y axis title and maximum. The charts will be similar in appearance and aligned properly.