Excel Burndown Chart: Download
View other templates here: Excel Templates
This template does not contain macros/VBA code.
Create your user stories or task list and add them in the column under Product Backlog items, then add in your expected effort (Story Points) under Beginning Balance.
Iteration number is meant for record keeping. It would be a place to enter in the current Sprint or Iteration. Expected Total Effort should not be touched, it auto calculates based on the Beginning Balance. The Days In Sprint field is optional. This is intended to give you a place to put a sprint duration in order to keep the ideal trendline accurate. By default, it assumes that your sprint duration is 4 weeks (20 days).
As each day passes, you place the number of story points completed under the appropriate day and on the appropriate Product Backlog Item line.
On the far right, it calculates the remaining story point balance and calculates the percentage complete for each product backlog item. There is a mini-burndown chart at the top of the sheet.
At the bottom of the sheet, it calculates the Ideal Trend and the remaining story points.
On the sheet titled “Burndown Chart” is a larger version of the mini-burndown chart.
Excel Reading Material
- Excel 2019 Bible
- Excel 2016 Bible
- Free EBook: I Will Teach You Excel: Master Excel, surpass your co-workers, and impress your boss!
- Excel 2019 All-in-One For Dummies