The Spade: A Football Analytics Newsletter

The Spade: A Football Analytics Newsletter

Tutorial: How to Make 3D Bar Charts in R

Tutorial Friday on a Monday

Ray Carpenter's avatar
Ray Carpenter
May 25, 2026
∙ Paid

Good morning everyone and happy Monday,

Sorry for the delay in the usual Friday tutorial. As promised, here’s the code I used to create 3D bar charts in R on our jumbo formation write-up from two weeks ago. I have two tangents to go on first though.

Image

Football Data Engineering Tutorial Update

Thanks to my friend Sam Hoppen (who you all should subscribe to for great football content) for reporting a bug to me in my football data engineering tutorial repository. Apparently none of you can open the football.duckdb file I’m creating as our database because DuckDB only allows one reader and one writer profile per database. To see the data, I recommend finding where I write the database, re-name the .duckdb file, and run the script this will now give you your own local copy. I will also be uploading a SQLite file in the same database for next week’s tutorial to make this more accessible. And let the record show this is now the second time I’ve tried to show DuckDB off in a more production-ish setting and the second time it has resulted in me returning to SQLite instead for a second time. I’m beginning to think DuckDB’s applications aren’t production ready yet, but it is a cool way to read large files quickly on your local.

Anyways, just wanted to provide an update there and let you know if you’re having issues with that repository, you aren’t crazy. Just level setting because I didn’t have the time to return to it this week. Appreciate the patience and here’s some R code for making 3D bar charts using ggplot, thanks everyone.

The Spade: A Football Analytics Newsletter is a reader-supported publication. To receive new posts and support my work, consider becoming a free or paid subscriber.

3D Bar Charts

User's avatar

Continue reading this post for free, courtesy of Ray Carpenter.

Or purchase a paid subscription.
© 2026 Raymond Carpenter · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture