When people think of Excel, they typically think of spreadsheets, budgets, dashboards, and data analysis. But Excel’s grid can also be used as a surprisingly effective canvas for creating pixel art and simple animations. As a fun experiment, I built a nighttime city skyline entirely from Excel cells. The buildings are made of colored cells, […]
Tag: Excel
Multi-Leg Route & Proportional Journey Mapping
In this post, I share my method of creating charts in Excel to visualize multi-leg journeys with time-proportions and icons using data. Once the structure is in place, they are scalable and data can be updated without ever needing to manually create any designs or artwork. A quick video intro to this article (more details […]
Python in Excel — Introduction (how and why)
Python in Excel is a feature that allows users to write and execute Python code directly within Excel spreadsheets. This integration enables advanced data analysis, automation, and visualization without needing external add-ins or additional purchases. Advanced, complex visualizations that are not possible directly in Excel is now possible with Python code that uses powerful libraries […]
Stock Data Acquisition And Analyses (Python, Excel)
The stock market is a prominent topic in recent public discussion. Rather than focus on the market itself, this post examines methods for acquiring stock data, reformatting it for use, generating various calculations and visualizations to facilitate analyses, and yielding insights. I will share my approach and point out some useful metrics and observations along […]
Do you know your leap years? Are you sure?
Many people remember to figure out whether a year is a leap year or not by checking if a year is divisible by four. If it is, it’s a leap year, meaning, the month of February of that year has 29 days and the year has 366 days, and if not, the month of February […]
Area Charts – Edgy to Smooth (various options)
Area charts are a great option when we need to show trends over time while also emphasizing the magnitude of values. They allow us to compare multiple series or variables easily, while the filled area illustrates the magnitude of values, and they also show how a part contributes to the whole over time. In this […]
What are the visual ranges of animals?
Visual ranges vary widely among animals due to differences in anatomy, habitat, and behavior. The visual ranges vary depending on the species even within the same animal. In this post, I share the distance up to which some selected animals are known to see clearly. Just for context, humans with good vision can clearly see […]
Creating Dynamic TTM Reports in Excel
In this post, I’m sharing a method to create various types of TTM reports including visualization using Excel. While there are various methods I have discovered, I believe my method presented here is fool-proof and also intuitive. It uses EOMONTH function for error-free calculation of each month’s end, and FILTER function to filter and fetch […]
Cartoon strip to a data-driven, interactive chart
Recently, I saw this cartoon strip on my Facebook feed from an account called “Homes”. It was sort of funny and true. But beyond that, I couldn’t help but think how much effort would it take to make this into a completely data-driven visualization? Don’t get me wrong, I’m a hobby artist (which you probably […]
When do we peak?
Recently, I came across an article stating how humans peak at different ages in different aspects. Surprisingly, and even perhaps amusingly it turns out that humans peak at different things throughout life from about 6 years of age all the way into the 80s according to the article based on scientific research. I captured the […]