If you have created a Mekko Graphics chart in Excel, you can use the same chart again, but with different data. Here's an example of how to re-use a cascade/waterfall chart. Select the Excel chart (single click) and then right click to choose Copy. Move to a different location in the same worksheet or add […]
About Diane Rich
Diane is an independent strategy consultant specializing in identifying and creating opportunities for companies to generate profitable growth. She has more than 20 years of management consulting experience working with clients ranging from early stage ventures and small businesses to large, multinational companies as both an independent consultant and with global firms, Bain & Company and Arthur Andersen. Diane has consulted with clients on the key strategic issues facing their businesses and she is known for delivering thoughtful, practical recommendations. Her consulting engagements have been as diverse as the mix of clients and include projects focused on growth strategy, customer segmentation, profit improvement and merger integration.
Diane served as the as Vice President of Business Development for Enzymatic Therapy, a private equity healthcare roll-up and as the Vice President of New Markets for iPhrase Technologies, an early stage software company.
She has a B.S. in Finance from the University of Illinois at Urbana-Champaign and an MBA from The Wharton School at the University of Pennsylvania.
Entries by Diane Rich
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, […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Recent Blog Posts