In this post, I demonstrate an effective way to reshape a CSV or XLSX file that originally has multiple rows repeating for each column. For example, many raw data exports will include a country’s metrics (GDP for example) for the year in each row and it repeats for different years as rows. Cntry Year GDP […]
Tag: Excel
Charting Team Lineups & Formations (Excel)
We have all seen the team lineups and formations graphics on TV for soccer (European football) games. It got me wondering if I could create a chart instead of a static image that can be easily scaled for any teams, any formations just by updating the underlying tables. It turns out, I can. It takes […]
Conditional Formatting Presentation (Excel)
Microsoft Quarterly Report was publicly released on April 25, 2024. It has tabulated data on year over year percent change in revenues by Microsoft fiscal quarter (Q1 is from July 1 through September 30). I tabulated the data from fiscal year 2023 Q1 through Q4, and from fiscal year 2024 Q1 through Q3 (Q4 data […]
Dumbbell Chart (Excel)
Dumbbell chart, aka Connected Dot plot is a type of chart that’s suitable for visually comparing values especially between two periods or showcase change. In this post, I demonstrate its usefulness as well some key steps on how to create one in Microsoft Excel (Office 365). Let’s start with the data. I have some data […]
Butterfly Chart (Excel)
Butterfly chart (aka Tornado or Divergent chart) is a type of bar chart used to compare two data sets side by side.It plots the data as two horizontal bars with the same X-axis in the center, resembling the butterfly wings.It gives a quick glance at the difference between two groups with the same parameters. It’s […]
How to make a perfect birthday cake in Excel
I’ve been exploring whether it’s possible to create a birthday cake-style chart in Excel. After some adjustments, I’ve reached a point where I can confidently say it’s achievable! You may ask, why not simply download an image from the internet? Well, that’s less engaging, potentially unlawful, and above all, it lacks the customization and scalability […]
Excel…aww…I love you too!
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Creating A Game Timeline Chart in Excel
BONUS VERSION Added on July 2, 2024 on a Euro 2024 game at end of the post. Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s […]
Electoral Votes by State/Jurisdiction
With the presidential election sneaking up fast, I thought it’d be good to get the latest electoral numbers by all states and District of Columbia based on the most recent census. So, here’s a map chart I created based on the published data. TIP: Use your mouse wheel while holding down Ctrl key on your […]
All About NFL’s Top Heach Coaches
I dug some information on some of the 32 head coaches in NFL today, and did some analayses. I was intrigued by their performance, compensation, their roots, their network and influence, correlations among various parameters like age, experience, wins, and salary. I also looked at how many teams they’ve coached in the past, and how […]