Marimekko chart of unicorn valuations by sector

Valuations of Recent Unicorn Exits

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:

Unicorn Exits chart only

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: