In this post, I’m sharing some data on number of vehicles, their density taking into account the population, and other interesting metrics for a selected number of countries around the world. The visualizations and analysis will take you on a journey of telling the stories and takeaways from the numbers. The selected countries presented here […]
Tag: Excel
Plotting ranges of values – Cat metrics
In this purr-fectly delightful blog post, I’ll guide you through steps to meaningfully depict ranges of values in Excel, all the while crafting irresistibly cute charts—no graphic skills needed! You’ll discover a few charts showcasing upper and lower values, Means, and custom markers. Using data such as the lifespans, weights, and prices of different cat […]
Funnel charts
In today’s data-driven world, visualizing complex information is crucial for making informed decisions. Among the myriad of chart types available, funnel charts stand out for their ability to represent the progressive stages of a process. Picture this: you’re diving into the analytics of a killer marketing campaign, tracking the journey of potential leads, or deciphering […]
Box and Whisker Plot Example
Here’s a scenario: We have data on gas tank sizes (gallons) for different types of vehicles for Japan and USA. Our objective is to create an informative plot to depict the gas tank sizes of both countries by vehicle type categories. One great solution is the box-and-whisker plot. This type of visualization effectively compares the […]
Top Lobby Spenders 2023-2024
Companies, labor unions, trade associations and other influential organizations spend billions of dollars each year to lobby Congress and federal agencies. 2023 was a year of the largest spending since 2014 from 12,900+ lobbyists spending $4.3 Billion (not adjusted for inflation). In 2024 YTD, $3.3 Billion have been spent by 12,500+ lobbyists. Not surprisingly, real […]
Combo Scatter Plots, Normalization
In this article, I am presenting two key concepts: combining multiple scatter plots into a single plot for easy comparisons, and bringing data on different scales to a common one via normalization so that they can be accurately compared. To illustrate those concepts, let’s start with two datasets: 1) Data on a class of students […]
Global Life Expectancies (2024)
Today, we’re gleaning life expectancy information and insights for some selected countries. We break it up by gender and try to analyze the underlying meaning behind the numbers. These countries are mostly selected due to the selection made for my earlier post about Global Health and Safety; then I added a few more and removed […]
Global Health and Safety Stats
In this post, we’re glancing at some key health and safety issues affecting human populations worldwide.From chronic illnesses to risks to lives posed by various human activities such as violence and traffic death, I’m presenting some easy-to-understand visuals and comparisons across most affected countries to selected developed and developing nations. The data have been sourced […]
Creating a half-circle and a rainbow chart
In this blog, I demonstrate creating a half-circle, and then a rainbow chart in Excel using data. The charts are dynamic and fully customizable. Other than just being pretty, they have plenty of uses (e.g. for seating arrangements in an arena, for showing counts of seats occupied by different parties, and much more. Besides, they’re […]
Altitudes Above Earth
Welcome to an exciting and educational view of the skies above us. In this blog, we’ll look at various altitudes where some of the most interesting objects and phenomena can be found. From the gentle drift of hot air balloons and the majestic flight of vultures to the high-speed travel of jet planes and the […]