The template can be download from – Template 03 – Agile Burndown Chart Template
Unprotected version of template – Template 03 – Agile Burndown Chart Template_Unprotected
I decided to create a template for a Burndown Chart in Excel which is very highly used in Agile Project Management. Next download template will be about Burnup Chart which is also a very highly used chart in Agile Project Management.
In this template, I am not constraining look and feel to only one type of Burndown Chart rather I am giving 4 different look and feel. You can use which one do you want to use.
How to use this Template
On the first tab, you can choose your legends – Planned Effort, Remaining Effort. Whatever you put here, the same will appear as legends in your chart.
Use Input tab to create your inputs.
In column A, you can put your Tasks, Stories or Sprints or any other parameter which you are using in your Agile Project. Column B can contain Planned Effort, Planned Stories depending upon your need.
Beneath the dates, you can enter the Effort Remaining, Stories Remaining etc. Once, you put 0, it means task is completed.
Following are the validations –
1. Remaining Efforts can not be > Planned Effort (Effort may mean Stories, Tasks etc. also. Put right words)
2. Next Day's Remaining Effort should be <= Previous Day's Remaining Effort
3. Negative entry is not allowed
4. Planned Effort, if entered, should be >=0
Also, if you have entered a weekend (Sat / Sun) as the dates, they will be highlighted in Orange to give you an indication that a weekend date has been entered.
This chart looks really good and useful. To enhance better, i would like to know the protected password of this excel. Could some one let me know?
Great charts, easy to use. thank you
donde esta el maldito archivo para descargarlo
Your template is protected >> Could I have a password to change it?
Updated the post with Unprotected version of the template.