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 […]
Tag: Excel
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 […]
Interesting Facts at Ocean Depths
Exploring the depths of the ocean reveals a fascinating world teeming with diverse marine life and remarkable human achievements and adventures.In this chart, we look at some of the usual depths inhabited by various marine creatures, from the shallow waters to the abyssal plains and down to the deepest seabed on Earth.Additionally, I highlight some […]
Creating an Analog Clock in Excel
Welcome back! In this post, I demonstrate creating an analog clock as a chart in Excel that’s completely data-driven, and even real-time. The clock, created as a scatter plot in Excel is dynamic, scalable, accurate, and highly customizable. You will discover the way to generate such a chart that updates the clock visual according to […]
Circle and Star charts in Python
In this post, I share the code on how to create a circle and a star chart using the very flexible XY scatter chart type and the very versatile matplotlib Python library. The number of lines of code needed are very small but the key here is to understand the parametric equations needed to generate […]