Entries by Diane Rich

Wine Customer Segmentation

I was intrigued by a recent Forbes article that described the U.S. wine market as the “most populous wine market on the planet.” The article was based on data from the Wine Intelligence 2018 portrait of the U.S. wine market. The report reveals that there are 84M regular wine drinkers in the U.S. and it […]

Spend Less Time Preparing Your Data

Do you spend a lot of time cleaning up your data before you create a chart? You can save time by utilizing the chart data sheet more effectively. Horizontal Stacked Bar Chart Example This chart from our Chart of the Week series shows the largest over-budget construction projects. It's a good example of how to use […]

How to Create a Marimekko Chart in Excel

If you’re new to the marimekko chart type, you’re in for a real treat. The marimekko is a visualization gem that allows you to break down a measure, like revenue or cost, into its components to understand each component's relative size. The marimekko combines data typically found in multiple charts (pie or bar) into a […]

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 […]