Entries by Diane Rich

Top 10 Airline Routes

Airline industry revenue data for 2019 showed the Top 10 airline routes (based on revenue) by airline. British Airways' New York (JFK) to London (LHR) route was the largest by revenue and was the only route to exceed $1B. Nine of the Top 10 routes actually posted revenue declines on a year over year basis. […]

Air Conditioning Around the World

The scorching summer in the Northern Hemisphere has left many with a renewed appreciation for air conditioning.  June was the hottest June on record, according to the National Oceanic and Atmospheric Administration (NOAA). Temperatures in France reached all-time highs and other cities in North America, Europe and Asia experienced record heat waves in both June […]

Top Genre Artists in US Music

The top 5 R&B/Hip Hop artists had the highest sales, but Ariana Grande was the top selling artist. In Pop, Country and Latin, the leading artist also had the top song for the genre. Data is for the first 24 weeks of 2019 from Nielsen's Mid-Year US Music Report. It is interesting to see the […]

High-Income American Women

There were nearly 72,000 women in the US who reported income of more than $500K to the IRS in 2016. That number has grown at 13% per year since 2009. The highest income segment (wages of $5M+) has grown at 28% over the same time period.  By comparison, there were 405,000 high-income men in 2016. […]

How to Reuse a Chart and Link it to Excel

If you would like to reuse a chart, you can simply replace the data in the chart data sheet with your data. To make it easier to update the chart, however, you may want to link the chart to Excel data. Here's how to do it. Step 1: Open the PowerPoint file containing the chart […]

Growth in US Music Industry Revenue

Music industry revenues in the U.S. were up $1B in 2018 according to the  2018 Year-End Music Industry Revenue Report released last week by the Recording Industry Association of America (RIAA). Streaming continued to be the dominant channel, reaching 50M subscribers and representing 75% of industry revenues. All other channels have been declining, especially digital […]

Net Promoter Score

The Net Promoter Score (NPS) was developed by Fred Reichheld from Bain as a simple measure of customer loyalty. It measures the likelihood, on a 1-10 scale, that a customer would recommend you to a friend. Survey responses are grouped into 3 categories: Promoters (score of 9-10), Passives (score of 7-8) and Detractors (score of […]

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