Category Archives: Bar-line chart

69% of US wage earners comprise just 30% of cumulative net compensation

The bar-line chart below examines the cumulative number of US wage earners in different net compensation brackets and their contribution to the cumulative net compensation in 2017. In addition, a data row is used to detail the average net compensation and percent of wage earners for every bracket.

At the highest differential, 69% of wage earners comprise just 30% of cumulative net compensation. Note that at about 95% of wage earners, there is a discontinuity due a significant change in bracket definition.

Bar-line chart examining wage earners and their net compensation

Bar-line chart showing cumulative number of US wage earners and their cumulative net compensation across different net compensation brackets in 2017

The data visualization above was built with the Aploris add-in for PowerPoint.

 

Bar-line chart showing players with the most goals scored in World Cup matches

The bar-line chart below shows the numbers of goals scored in World Cup matches by the top 22 players. The bar indicates the number of goals and line shows the number of goals per game. In addition, we use data rows to list the number of games each athlete played in.

Miroslav Klose has scored the most the goals with 16 across 24 games. France’s Just Fontaine and Hungary’s Sándor Kocsis took only 6 and 5 games, respectively, to score 13 and 11 goals, having highest goals/game average and more than double the next highest.

Bar-line chart showing the 22 of the overall top goal scorers in World Cup matches

Bar-line chart showing players with the most goals and their average goals per game in World Cup matches

This chart was built using the Aploris add-in for PowerPoint on a Mac.

Worldwide cereal production, utilization, and stocks

The combination bar-line chart below shows worldwide cereal production, utilization, and stocks on a yearly basis. In addition, a data row is used to compare the stock levels with the utilization. To clearly show the data, which is spread over a large range, two axes are used. The left axis begins at 1800 million tonnes to amplify the delta between production and utilization.

Production has consistently been higher than utilization which leads to an increase in the available stocks. Further stock levels as a fraction of utilization have also increased slightly.

Bar-line chart showing worldwide cereal production, utilization, and stocks

Cereal production and utilization depicted in a combination bar-line chart

This chart was built using PowerPoint 2016 for Mac and the Aploris PowerPoint add-in.

Bar-line chart showing percent of words spelled correctly by word length in Scripps National Spelling Bee

Bar line chart below shows the percent of words spelled correctly by word length at the Scripps National Spelling Bee from 1996 to 2016. The bars indicate the share of words spelled correctly and the line shows the number of words. The most common word length is 9 letters. The data shows that longer words are not necessarily harder to spell. 3 letter words have appeared three times but only spelled correctly once. The two longest words, 19 and 21 letters in length, were both spelled correctly the one time each came up in competition.

Bar and line graph showing Spelling Bee word lengths and correctes rates

Bar line chart showing percent of words spelled correctly by word length in Scripps National Spelling Bee, 1996-2016

This chart was built using Microsoft PowerPoint 2016 for Mac and the Aploris add-in.

Bar-line chart showing 10 highest grossing movie franchises

The chart below shows the total revenue for the 10 highest grossing moving franchises (bars) and the average revenue per movie (line). In addition, a data row is used to indicate the number of movies per franchise. The Marvel franchise has the highest total gross but J. K. Rowling’s Wizarding World averages more revenue per movie.

Bar-line chart showing 10 highest grossing movie franchises

Bar-line chart showing 10 highest grossing movie franchises and average revenue per movie (USD)

This chart was built using PowerPoint for Mac and the Aploris add-in.

Bar-line chart showing coffee consumption in top 20 countries

The combination stacked bar-line chart below showing coffee consumption in the 20 countries with the highest consumption per capita. The bars indicate cups of coffee consumed per day per capita. The line indicates the total coffee consumed in millions of cups. We use a data row to indicate the country population.

While Netherlands consumes almost twice as much coffee per capita as the next highest country, the US’s total consumption is significantly greater than any other country.

Coffee consumption bar-line chart

Bar-line chart showing coffee consumption in top 20 countries by capita

This chart was built using PowerPoint for Mac and the Aploris add-in.

Bar-line chart showing rent economics across major US cities

The bar-line combination chart below highlights the rental economics in several major US cities. The bars indicate the amount of space in square feet you can expect to rent for $1500/month. The line shows the average rent.

Bar-line chart showing amount of space you can rent for $1500

Bar-line chart showing amount of residential space you can rent for $1500 across major US cities

This chart was built using the Aploris add-in for PowerPoint on a Mac. Aploris facilitates the creation of a variety smart business charts in PowerPoint including waterfalls, bar charts, and Mekkos.

Bar-line chart comparing the best public transportation systems

The combination bar-line chart below compares public transportation systems across 5 major cities. The bar chart shows the number of miles of track and the line chart shows the yearly ridership level.

New York has the most miles of track and Beijing has the highest ridership. The axes were adjusted to minimize the amount the columns and line series overlapped. Additionally, the number of stations within each transportation system can be found as a row of annotated data below the group descriptions. We decided that adding this information to the plot area is not needed to convey the primary insights and could over-complicate the graph. Annotated data can be helpful in cases like this where auxiliary figures are helpful for some readers which will easily find them upon a closer look.

Bar-line chart examining public transportation systems across 5 cities

Chart comparing miles of track and ridership across 5 major cities

This chart was created using Aploris on a Mac (OS X) with Office 2016.

Bar-line chart comparing length of work week and year for Western European countries

The bar-line chart below compares the length of the work year in working hours (bar) and work week (line) for several Western European countries in 2014. In addition, a data row is used to compare the number of work weeks in a year.

Bar-line chart showing yearly working hours across several Western European countries

Bar-line chart showing yearly working hours across several Western European countries

Germany has a relatively typical work week length but has the short work year and therefore the fewest number of working weeks. The Netherlands have the shortest working week but a number of working weeks above the average.

The bar-line chart allows us to plot two separate but connected values. Two axes are used to take the different dimensions of yearly and weekly hours into account. The axes were set such that the bars and line do not run into each other making therefore the series stand out clearly. This was achieved by setting a specific axis maximum value. We also rotated this chart to help make the country labels easier to read.