Entries by Diane Rich

10 Excel Tips You Should Know

The HBR article, 10 Excel Functions Everyone Should Know, inspired this list of 10 of the most useful features for creating Mekko Graphics charts in Excel. 1. Format All Labels The default chart size in Excel is smaller than in PowerPoint, so you may have less space for labels. You can make the chart larger, […]

Funding for Higher Education Around the World

The OECD recently released a state of education report, which was referenced in the Forbes article, The Crazy Amount Americans Spend on Higher Education, In One Chart. The article showed a spending comparison per student by country and concluded that tuition is so high in the U.S. due to high per student spending. Another dataset from […]

Comparing Wealth and Cost of Living by State

If I asked you “Which state has the highest % of millionaires?” the first state that comes to mind is likely California. So, you may be surprised to see that Maryland has the highest percentage of millionaires (7.87% of population), followed closely by New Jersey.  The data is from an Inc article and millionaire is […]

Growth in U.S. Wine Consumption

I found some interesting data about the U.S. wine market in a recent report published by the consulting firm, LEK. The report showed that consumption is expected to increase at a 6% CAGR over the next 5 years, bringing the market for wine to $43B in 2022. When you look at the forecasted consumption by […]

The Price of a Pint of Beer Around the World

After several weeks of technology charts, I thought it would be refreshing to look at beer prices around the world. Visual Capitalist recently featured this data in a map, but it's also well-suited to a horizontal bar chart. There are many factors that influence beer prices, including cost of living, currency values and taxes. It's […]

Top North American Cities for Tech Jobs

I read a recent TechVibes article about Canada’s ascendance in the technology market and thought that a bubble chart would be a great way to showcase some of the data. I knew that Toronto was a popular startup destination, but I was not aware that it's a Top 5 market for tech talent. It’s the […]

A Rough Quarter for Some Tech Stocks

Technology stocks have been the talk of the earnings season. 3 of the 4 FANG (Facebook, Amazon, Netflix and Google) internet stocks have declined since their earnings release as shown in the bar mekko chart below.  We shared Netflix’s quarterly subscriber numbers when they released earnings on July 16. The stock fell immediately after and […]

Snapshot of The Championships, Wimbledon

Qualifying rounds for The Championships, Wimbledon have commenced and the main draw for the tournament begins next week. Prize money is up 8% over 2017, as shown in the stacked cascade chart, and most of that will go to singles players. Singles players in the earlier rounds will receive larger percentage increases in prize money […]