Sunderland Data Visualization: A Fan's Guide to Making Sense of the Stats
Let’s be honest, as a Sunderland fan, you live and breathe this stuff. Whether it’s dissecting the latest Wear-Tyne derby performance, tracking our progress back up the leagues since our time in EFL League One, or just trying to work out our form at the Stadium of Light, there’s always a stat to argue over. But spreadsheets and league tables can be, well, a bit dry.
What if you could turn those numbers into something that tells a story? That’s where data visualization comes in. It’s about making sense of the stats that define our club—from the glory of the 1973 FA Cup Final to the journey under Kyril Louis-Dreyfus—in a way that’s clear, compelling, and perfect for sharing in the group chat or on fan forums.
This guide is your practical toolkit. We’re going to walk through how you, as a fan, can create your own simple but powerful SAFC data visuals. No need for a degree in data science; just your passion for The Lads and a bit of time.
What You'll Need Before You Start
Don’t worry, the shopping list is short. You won’t need expensive software or to be a coding wizard.
- Your Data: This is the fun part—choosing what story you want to tell. It could be:
Historical: League finishes over the decades, cup runs, results in the EFL Trophy.
Squad Analysis: Appearances, goals, assists across a season or era (think the Jack Ross era vs. the Tony Mowbray period).
- A Data Source: Where will you get clean numbers?
Fan Sites & Forums: Often have compiled historical stats.
Wikipedia: Surprisingly robust for basic historical tables (just double-check!).
Your own season ticket history spreadsheet? Why not!
- A Tool: We’ll focus on free, accessible options.
Canva: Fantastic for making those visuals look slick and shareable on social media. It has built-in graph tools.
A Notepad & Pen: For sketching your idea first. Seriously, planning is key!
Your Step-by-Step Process to SAFC Data Visuals
#### Step 1: Find Your Story in the Stats
Start with a question. A good visualization answers something. Don’t just plot “goals.” Ask:
“How has our defensive record improved since leaving League One?”
“What’s our historical win rate at the Stadium of Light versus the old Roker Park?”
“How does our academy output—think Academy of Light graduates—compare to five years ago?”
For this guide, let’s choose a question many of us ponder: “How does our performance in the first half of the season compare to the second half over the last five years?” It tells a story about consistency, momentum, and maybe even January transfer impact.
#### Step 2: Gather and Clean Your Data
Head to your chosen source (let’s say the EFL website or a stats aggregator) and find the final league tables for the last five SAFC seasons. You need: Season, Total Points, and ideally, a breakdown of points at the halfway mark (after 23 games).
Create a simple table in Excel or Google Sheets:
| Season | Final Points | Points at Game 23 |
| :--- | :--- | :--- |
| 2023/24 | 69 | 36 |
| 2022/23 | 69 | 40 |
| 2021/22 | 84 | 47 |
| 2020/21 | 77 | 41 |
| 2019/20 | 48 | 26 |
(Note: Example data used for illustration. Points at Game 23 may need estimating for some seasons.)
“Cleaning” just means checking for errors. Make sure the seasons are in order and the numbers look right. A quick sense-check against your memory (that promotion season under Alex Neil in 2021/22 was a strong one!) helps.
#### Step 3: Choose the Right Chart Type
This is where you make the numbers speak. For our “half-season comparison,” a grouped bar chart is perfect. It will let us see the two bars (First Half Points vs. Final Points) side-by-side for each season, making comparison intuitive.
Other ideas:
Line Graph: Perfect for tracking league position week-by-week through a dramatic season (the Sunderland Echo often runs these!).
Pie Chart: Use sparingly! Good for showing, for example, the proportion of goals scored by strikers vs. midfielders in a season.
Scatter Plot: Could show the relationship between possession and points gained in away matches.
#### Step 4: Build Your Visualization
In Excel/Sheets:
- Highlight your data table.
- Click “Insert” > “Chart.”
- In the Chart Editor, choose “Bar Chart” and then “Grouped Bar Chart.”
- Your seasons should be on the vertical axis, and points on the horizontal.
- Give it a clear title: “SAFC: First Half vs. Full Season Points (Last 5 Seasons).”
In Canva:
- Search for “Bar Graph” in the elements tab.
- Click “See all” and you’ll find a data editor where you can input your numbers directly.
- Customize the colors—make them SAFC’s iconic red and white stripes! Use red for “Final Points” and white with a red outline for “Points at Game 23.”
#### Step 5: Make It Unmistakably SAFC
This is what separates a generic chart from a Black Cats visual.
Color Palette: Use red, white, and black. Always.
Labels & Titles: Use clear, bold text. Add a small, subtle club badge as a watermark if you like.
Context is King: Add a one-line insight. For example, next to the 2021/22 bar, you could add a text box: “Promotion Season - Strong finish.” This turns data into narrative.
#### Step 6: Share and Discuss!
You’ve created it, now share the story. Export it as a clean image (PNG or JPEG).
Use it to illustrate a point on a forum like Ready To Go.
Even print it out for the pub before the match! The best visualizations start conversations, confirm hunches, or even reveal surprising truths about our beloved club.
Pro Tips & Common Mistakes to Avoid
Start Simple: Your first viz shouldn’t track every player’s pass completion since 1992. One clear story is better than ten muddy ones.
Label Everything: Assume the person seeing it knows nothing. What does “Points 23” mean? Label it “Points after 23 Games (Halfway).”
Don’t Distort the Story: Starting your bar chart axis at 20 instead of 0 can make small differences look huge. Be honest with the scale.
Beware of Pie Chart Overload: Slicing a pie into 10 tiny pieces is useless. If you have more than 5 categories, use a bar chart instead.
Cite Your Source: A tiny “Data: SAFC/EFL” in the corner adds credibility.
Think About Your Audience: A detailed chart for a hardcore analytics forum can be more complex than one for a general Facebook group.
Your SAFC Data Visualization Checklist
Ready to get started? Here’s your at-a-glance guide to creating a great Black Cats visual:
[ ] Define Your Question: What SAFC story do I want to tell with data? (e.g., form, history, squad analysis).
[ ] Gather Data: Find reliable numbers from official sites, fan archives, or the Sunderland Echo.
[ ] Clean & Organize: Put data in a simple table, check for errors, and ensure it’s logical.
[ ] Choose Chart Type: Match the story to the visual (Bar, Line, Pie, etc.).
[ ] Apply SAFC Identity: Use red, white, and black colors; add clear titles and club context.
[ ] Refine & Simplify: Remove clutter, ensure labels are clear, and highlight the key insight.
* [ ] Share & Engage: Export and post it where fellow fans can see it and debate it!
The history of Sunderland AFC is written in results, tables, and numbers. By visualizing them, you’re not just looking at stats—you’re telling the ongoing story of our club. Now go on, see what story you can find in the data. Ha’way the Lads!
Reader Comments (0)