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 […]
Search Results for: soccer
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 […]
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
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 both beautiful, elegant and conveys the key events of the game without overwhelming the viewer with too […]
Timelapse animation in Excel
Not long ago I demonstrated how to create and share animated charts using Excel (search for “soccer” or “excel” in the search box of my site). Here, I present a cool 3D chart created in Excel with various dimensions including time and geo-location. This animation is based on a dataset for power stations across different […]
Anatomy of a goal (part 2)
This is a continuation of the original soccer goal tracking chart and animation posted @: https://flyingsalmon.net/blog/?p=869 It’s recommended that you read that blog first for context. In this blog, I added actual players involved in that goal (denoted by their jersey and individual numbers). The players data are added as an addition series (much like […]
Behind every goal, there’s science. Anatomy of a goal (part1)
With the World Cup, Copa America underway, obviously I try to catch some games and follow the scores on matches I missed. The other day I noticed a chart on BBC site that showed charts with points plotted on a field where the ball had traveled on a particular game. This got me thinking, how […]