🚴‍♂️ 11 Years of Cycling Visualized – Each Bike as Its Own Line, Tracking Over 20,000 km Since 2014 [OC]

Over the last 11 years, I’ve tracked nearly every kilometer I've ridden. This chart shows the cumulative distance ridden with each of my bikes over time. Each colored line represents one bike, and its trajectory shows when and how actively I used it.

🗓 The x-axis is time (years from 2014 to now)
📈 The y-axis shows cumulative kilometers per bike
📌 At the end of each line, you’ll see the total distance and average km/day for that bike
🌱 In the background: vertical green bars show individual ride distances by day
📊 Each calendar year includes a total yearly distance (Σ) above the timeline

Currently, I export all my data from Stats Hunters, which is essentially my Strava data but easier to export. Unlike Strava, where exporting data via Takeout is limited to a few downloads per week, Stats Hunters allows more convenient and frequent exports. After exporting, I import the data into Google Sheets where I clean and process it to create this visualization.

Highlights:

• My oldest tracked bike ("Gimondi Vintage") alone covered over 5700 km.
• In 2024, I had my strongest cycling year yet, surpassing 5000 km.
• My current favorites are the Specialized Sequoia and Titus El Viajero, both pushing 10–14 km/day on average during peak use.
• You can even spot short intense phases (like one day/week/month).

Why I made this:
I love data and cycling equally — and wanted a visual way to reflect how my bikes have accompanied me over time, through different phases of life and fitness. This was built with a google sheet and a bit of patience.

If you’re into cycling, data viz, or just enjoy looking at how hobbies evolve over time, I hope you find this as satisfying as I did putting it together!