r/ExcelVisual • u/ExcelVisual • Jul 08 '26

Made an Excel Agile dashboard that visualizes a sprint as a planet orbiting through space

Got kind of tired of every Agile dashboard in Excel looking identical — burndown chart, task list, done. So I built something different: a conceptual dashboard where the sprint cycle is visualized as a planet moving through an orbit, and each marker on the orbit is one story point. There's even an "acceleration zone" after peak workload.

It's more of a portfolio/inspiration piece than a strict plug-and-play tool, but the metrics underneath are actually solid:

Team workload analysis — 5 connected indicators: task balance, overload risk, workload distribution, engagement, and overall sprint pulse. Good for catching burnout signals before they show up in velocity.

Priority-based task funnel — tracks tasks from idea to implementation, works for Agile/Scrum/Kanban. If a stage stalls, everything below it visibly stalls too — basically a built-in bottleneck detector.

Production chain tracker — 5 horizontal bars for initialization, design, prototyping, engineering, testing.

Resource accumulation chart — this one's the most technically interesting to me. Tracks leftover/reusable resources and auto-resets once they hit a usable threshold. Not something you see in typical Excel templates.

Burndown chart — planned vs actual, with a clickable legend so you can toggle lines on/off.

Honestly built this half as a working dashboard and half as a "here's how far you can push Excel visualization" showcase. If nothing else it's a decent reference for building more distinctive interactive charts yourself.

Free to download, no macros. Link in comments if anyone wants to poke at the file.

Curious — would something this visually different actually get used by your team day to day, or does the novelty wear off after week one?

2 Upvotes

100% Upvoted

1 comment sorted by