The NETWORKDAYS function in Excel is handy for this. You can elect to simplify of course.įirst, you can get the number of calendar working days between a start and end date. To figure out the amount of work that can be done in a sprint, in its simplest form, is calculate the total number of developer or person-hours collectively available. The key thing the Burn Down chart will show is a plot of the amount of planned work against the amount of remaining work. Setting up the Sprint Information for Your Excel Burndown Chart We’ll break the task of creating an Excel burndown chart into four main groups. In agile or iterative development methodologies such as Scrum an Excel burndown chart is an excellent way to illustrate the progress (or lack of) towards completing all of the tasks or backlog items that are in scope for the current iteration or sprint.Įxcel can be an effective tool to track these iterations, or sprints, as well as report on the progress using a burndown chart in Excel.

Power trend lines in excel 2016