The 44 unicorns that had exit events in 2015 and 2016 had valuations of just under $100B. Healthcare made up the largest sector accounting for almost 1/3 of the total exit valuation. Stemcentrx and Acerta Pharma were the healthcare companies with the highest valuations. The next three sectors were all information technology related--Internet, Mobile and Telecommunications and Computer Hardware and Services. These three sectors combined for over half of all exits by valuation. Most of the unicorns were not consumer-focused and easily recognizable. The few that were included Jet.com, Etsy, Dollar Shave Club and Fitbit. The data from CB Insights is summarized in the Marimekko Chart below:
Creating the chart from a data table on the CB Insights website was relatively easy. I used an Excel PivotTable to organize the data for the Marimekko chart. I copied the data from the CB Insights Unicorn Tracker and pasted it into a spreadsheet. The tracker contains all exits from 2009- present with information on exit date, geography, industry category, round, exit valuation and total raised before exit. I used the data table to create a PivotTable with industry category as the columns, company as the rows and exit valuation as the data. I used the filter to restrict to 2015 and 2016 exit dates.
I first used the Mekko Graphics Excel add-in to create a chart in Excel based on the PivotTable with data restricted to 2016. This gave me a good sense that the chart had some valuable insights. I then changed the filter to include 2015 and 2016 exits. The chart looked better and I then used the Chart in PowerPoint feature of the Excel add-in to create the chart that you see above in a PowerPoint presentation.
Mekko Graphics version 8 has some new features that made it easier to create the chart. I used the new Color After Sort option to apply my color palette to the chart segments after I sorted them with biggest industry on the left and biggest segment on the bottom. I also used the new fast formatting to multi-select and right-click on a segment label, bar total, and grand total and format those numbers as $B with one decimal place. I then did some minor adjustments to some bar and segment labels to get them to better fit and not overlap. I also removed the chart border, axis lines, and axis tick marks to give a cleaner look to the chart.
Here is the chart in SlideShare to download and edit using Mekko Graphics: