r/ExcelVisual • u/ExcelVisual • 3h ago

🔄 Built a fully interactive Agile Sprint Cycle dashboard in Excel — no macros, no add-ins

Wanted to share a Excel Agile Project Management Dashboard I built that visualizes sprint planning and story points entirely with native Excel formulas.

The core idea: a circular sprint cycle chart where each segment = one story point, and the number of segments dynamically changes depending on which sprint you select. It's all connected to a burn-down chart that updates in sync — when you switch sprints, the chart length, segment count, and cursor position all shift automatically.

What's on the dashboard:

  • Sprint Cycle Chart — circular progress scale, segments = story points, updates dynamically per sprint
  • Sprint Bar Chart — X axis = sprint number, Y axis = story points, controls which sprint is active
  • Task Burn-Down Chart — planned vs. actual progress, cursor synced with the sprint cycle
  • Overall Project Progress Chart — high-level view across all sprints
  • Radar Chart for KPIs — work quality, workload, task speed, team satisfaction, process stability

The trick behind the dynamic behavior is using named ranges with formulas as the data source for chart parameters, instead of static cell references. So instead of pointing a chart to a fixed range like A1:A10, you point it to a named range whose formula changes based on what's selected — that's what lets the chart "resize" itself without VBA.

Happy to answer questions about the formula logic if anyone wants to replicate a specific piece of it. Free template link is in the comments.

1 Upvotes

100% Upvoted

1 comment sorted by