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 […]
Tag: Excel
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 […]
Identifying double-bookings, scheduling conflicts
You’ve created a week’s schedule for your restaurant staff by day and shift (AM or PM). Next, you want a way fool-proof method to check if anyone is double-booked on any given day, and if so, who. Surely you can manually double-check and triple-check to make sure the schedule is exactly as planned but there […]
Penalty Shootout Data and Presentation
One of the most thrilling games in the Euro 2024 was one of the quarterfinals between France and Portugal that was tied at 0-0 after the regular + extra time resulting in a penalty shootout. France won 5-3 in pks. I wanted to create a couple of dynamic charts based on some basic data from […]
Paris Summer Olympics 2024 Stats
As the world eagerly watched the Paris Olympics 2024 from start to conclusion, I was fascinated by the amazing feats of the athletes from around the world. In this post, I present analysis of the performance of some nations and their athletes. You’ll find a collection of statistics, charts, and visualizations that highlight some key […]
How to create Overlapping Charts in Excel
Sometimes a seemingly simple visual can be difficult to convey with a built-in Excel chart. I present here such an example. For instance, I will describe how and why to create an Overlapping Column Chart, aka 100% Overlapping Column Chart in Excel. It can also be turned into an Overlapping Bar chart. Say, we have […]
How To Pick Rows Or Columns, And Combine Them With Other Functions For Powerful Uses. Part 2
In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: DROP(). In another blog, I discuss […]
How to pick rows or columns, and combine them with other functions for powerful uses
In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: TAKE(). In the next blog, […]
Euro 2024 Analyzed with Visuals
Introduction With the summer of soccer, beautiful football having come to an end, let’s dive into some team and player statistics and assay the tournament. I have collected various stats and facts, and organized them into a digestible format as a tribute to the fantastic players and the tournament. In this post, I’ll cover some […]