Category Archives: Bar chart

Growth of Asian billion dollar startups

The bar chart (A) below shows that billion dollar startups have grown at 81% compound annual growth rate (CAGR) over the last 2 years lead by those in Asia. Asian startups have outpaced other regions growing at 126% CAGR. Across regions both the number of billion dollar startups and the average valuation has increased. Note that foreign exchange rates can also have an impact on valuations. For example, the Euro has become significantly weaker compared to the US dollar over the last two years.

Funding for billion dollar startups

Bar chart showing total valuation of billion dollar startups by region

The Mekko chart (B) below provides an overview of the Asian startups by industry. The area of each square is proportional to the valuation of the startup it represents.

Mekko of Asian startups

Mekko chart of the Asian startup landscape by industry

Asian startups are largely focused on E-commerce and Hardware, which make up a larger portion of the total landscape than in other regions. E-commerce and Hardware comprise 60% of the total value of Asian billion dollar startups. Surprisingly, there is only one billion dollar startup, InMobi, in the Software industry. In other regions, Software is 26% of the total value but in Asia it only makes up 2%. However, these ratios are subject to significant fluctuation as startups are funded, experience growth, and potentially exit (e.g. go public, get acquired).

download pptfree trial

 

 

 

The stacked bar chart (C) below shows funding in these startups over the last 2 years. Overall funding has grown at 88% CAGR with the average funding per startup also increasing. Funding in Asian startups is growing significantly faster (128%) than the US (70%) but lagging the smaller Europe (162%).

Funding for billion dollar startups

Bar chart showing funding for billion dollar startups by region

The bar-mekko (D) below shows valuation-to-funding ratio (height of segment) and the total funding (width of segment). As such, the area of each segment is proportional to total value of all the startups in the region. US and Asian startups have similar valuation-to-funding ratios.

Valuation-to-funding ratio

Bar-mekko showing valuation-to-funding ratio by region

download pptfree trial

 

 

These charts were built with the Aploris PowerPoint add-in. Source data for these charts from the WSJ.

Stacked bar chart comparing calories in a signature burger and fries at different fast-food restaurants

The stacked bar chart below shows the calories in a signature burger and medium fries at common fast-food restaurants. In addition, the data rows show the fat and sodium content for the total meal.

In-N-Out’s double-double and medium fries has the most calories at total of 1,065. The In-N-Out meal also has the most fat and sodium. As a next step, normalizing the calories to the size of the meals might provide additional insights.

Stacked bar chart comparing calories for signature burgers and medium fries at fast-food restaurants

Stacked bar chart comparing calories for signature burgers and medium fries at fast-food restaurants

This chart was built with Microsoft’s PowerPoint and the Aploris add-in on a Mac running OS X. The data rows are a part of the chart and can be configured automatically with Aploris.

Stacked bar chart showing user engagement growth on Product Hunt

The stacked bar chart below shows the number of votes and comments by Product Hunt users on a monthly basis. In addition, a data row is used to show the number of products featured.

Growth arrows are used to show the compounded monthly growth rate of comments and votes. Over the last 11 months, the growth rate has stalled to 1% compared to the 24% achieved over the previous 12 months.

Stacked bar chart showing growth of user engagement at Product Hunt

Stacked bar chart showing Product Hunt user votes and comments on a monthly basis

This bar chart was built in PowerPoint using the Aploris for Mac add-in. Aploris enables users to quickly create a variety of charts including Mekkos and Gantt charts. In addition, with Aploris you can add visual elements like growth arrows, delta bridges, and data rows/columns.

 

 

Bar chart showing hours of binge watching required to finish popular TV shows

The bar chart below plots the number of hours required to binge watch select popular TV shows. Grey’s Anatomy tops the list with a whopping 164 hours (almost 7 days) needed to watch all the episodes.

For a clean look this chart omits the y-axis. Data provided by Nielsen.

Bar chart showing time needed to binge watch shows

Bar chart showing time required to binge watch select popular tv shows

This chart was built using the Aploris for Mac add-in with PowerPoint for Mac. Request a free trial and start quickly building smart, intuitive PowerPoint charts.

 

Stacked bar chart showing happiness score for select countries

The bar chart below show the happiness scores for select countries along with the 95% confidence interval. In addition, a data row is used to highlight the country’s overall ranking. For each country the segments in the stack show how the scores can explained by various factors.  For examples 1.0 of the United States’ 7.1 score can be explained by social support.

Denmark leads the world with an overall score of 7.5 driven by GDP per capita and social support.

Bar chart showing happiness scores

Stacked bar chart with confidence intervals showing happiness scores for select countries

This bar chart, including the data row and error indicators, was built with the Aploris add-in for PowerPoint on a Mac.

Bar chart showing longest commercial flights

The bar chart below show the distance for the top 5 longest commercial flights. In addition, the data rows below the chart show the duration of the flight and the airline that flies it.

Emirates flies the longest commercial flight at 14,203 kilometers between Auckland and Dubai that takes just over 17 hours.

Bar chart showing longest commerical flights

Bar chart with data rows showing top 5 longest flights

This bar chart was created by a PowerPoint add-in called Aploris on a Mac.

100% stacked bar chart showing how Americans spend their average weekday and weekend

The 100% stacked bar charts below explain how Americans spend their average weekday and weekend. The chart includes two data columns that detail the percent of Americans that participate in each of the activities.

As expected, Americans spend less time working and more time on personal care (including sleeping) and leisure/sports on weekends. However, 24% of Americans spend some time working on weekends.

This chart was built using a Apple MacBook Pro with Aploris for Mac and Office 2016 for Mac.  The data column is a standard feature with Aploris and does not require manual editing.

Stacked bar chart showing how Americans spend their day

100% stacked bar chart explaining how Americans spend their average weekdays and weekends

How the time we spend cooking has changed

Over the last 50 years, significant advances in food technology and the rise of food corporations have undoubtedly had an impact on how we eat. Work by the NIH, recently brought to our attention by food writer Michael Pollan, has highlighted how the time we spend cooking has also changed.

The cluster chart below outlines the average time US adults have spent cooking between 1965 and 2008. The bars indicate the minutes per day spent by men and women who cook, while the data row specifies the percentage of men and women who cook. In general, fewer women cook and spend less time cooking in 2007-08 compared to 1965-66; conversely, more men cook and spend more time cooking in 2007-08 compared to 1965-66.

In 1965-66, women spent an average of 104 minutes per day cooking meals while men spent only 10 minutes.  As more women started also working outside the home, their cooking time dropped to 44 min per day in 2007-08. Men, however, have not completely balanced out this shift, as their average time spent cooking has only increased to 19 min per day in 2007-2008. As a result, the average time spent cooking per day has dropped from 114 minutes to 63 minutes.

 

Cluster chart showing changes in time we spend cooking

Cluster chart examining how the time US adults spend cooking has changed

The cluster chart above was built in PowerPoint using the Aploris plug-in/add-in.

Since US adults have increased caloric consumption over the last 50 years, this data would indicate that US adults are either consuming more food outside the home or are relying on packaged food to offset the reduced time spent cooking. Such changes have likely had a significant impact on the nutritional quality of the food we eat.


At Aploris we build productivity tools for PowerPoint users.  Our data visualization add-in helps users create a variety of charts including Mekkos, waterfalls and Gantts.  Our new product, TeamSlide, is a slide management solution embedded in PowerPoint that helps users better access their team’s shared content (slides, visuals, charts, etc.).

Cluster bar chart comparing calories burned for different exercises

The cluster bar chart below compares the calories burned by completing a 30 minute session of different activities. The cluster chart is used to provide two data points for each activity: one for a 125 pound person and one for a 185 pound person. The chart is grouped in 4 segments based on the activity type. The grouping was achieved by increasing the spacing between some columns.

Of all occupational activities, firefighting required the most calories. Not surprisingly, computer work required very few calories.

Calories burned by different exercises

Calories burned doing different activities for 30 minutes

This chart was built with Office 2016 for Mac and the Aploris add-in.

Histogram of number of hours Americans work

The bar chart below represents a histogram of the number of hours Americans work a day. A histogram is a bar chart where the height of each bar is proportional to the frequency of a variable at a certain value. For example, of Americans that worked, 13% worked 8 hours a day and 95% worked 12 hours or less.  The sum of all the frequencies adds up to a 100%.

Bar chart of number of Americans daily work hours

Bar chart histogram of the number of hours Americans work a day

This bar chart/histogram was built using Aploris on a Mac with OS X.