Is There Too Much to Watch on Television?
The number of original scripted television series grew 12% per year from 216 in 2010 to 487 in 2017. Online services like Netflix and Amazon accounted for a large part of the growth as shown in this stacked bar chart with a CAGR column and growth line. They produced 4 TV series in 2010 and 117 in 2017, according to data from FX Network Research published in Variety. Other distribution channels also produced more TV series. Broadcast networks' production grew 4% per year from 113 to 153 series. Basic and pay cable grew 13% and 8%, respectively. They produced 175 and 42 series in 2017, up from 74 and 25 in 2010.
Stacked Bar Chart
How I Created The Stacked Bar Chart
The stacked bar chart shows both overall growth in scripted television series and growth in each distribution channel. I used the CAGR (Compound Annual Growth) figures for each channel to make it easier for the reader to compare the growth rates of online, cable and broadcast to each other and to the total shown on the CAGR growth line. Adding the year over year growth in the data row allowed me to show that there were two leaps in growth (from 2010 to 2011 and from 2012 to 2013).
Here are the steps I followed to create this chart:
- input the numbers for each channel and year (4 by 7 or 28 in total) into the Mekko Graphics Data Editor
- create formulas in the Data Editor for CAGR column and year over year growth in the data row
- add the CAGR column, data row, Y axis title, legend aligned to CAGR column, and growth line (set to CAGR instead of Absolute)
- adjust margins
- format the data row to show as percentage
- annotate the labels for 2010-2012 online services
- adjust series colors to increase contrast among cable, broadcast and online series
Take This Chart and Make It Your Own
Download this chart and edit it using Mekko Graphics. To learn more about bar charts, see these examples in our Chart Gallery or look at this horizontal stacked bar in Chart of the Week. Watch this video to learn more about how to use CAGRs in your charts.