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: