author image

By Denis G.

3 minutes

Burn Down Chart Template

A burn down chart provides a graphical representation of the work left to perform plotted against time. They are most commonly used during Agile software development to burn down the work remaining in the current sprint. If you’re involved in Agile project management you’ve probably seen these before, if not, read on and we will take you through it so that you have all the knowledge and understanding you need to work in this way. Below is an example of a burn down chart:

Burn Down Chart Template Example

What this example is showing is that we have 300 story points to complete in 20 days (4 working weeks). The “Planned” line shows the plan we are aiming to follow at the beginning to the sprint. The “Actual” line shows how we’re progressing against this plan. The “Actual” line is interpreted as follows:

  • If the “Actual” line is above the “Planned” line then we are behind schedule. Essentially, there is more work than predicted, resulting in us being behind schedule.
  • If the “Actual” line is below the “Planned” line then we are ahead of schedule. Essentially, there is less work than predicted, resulting in us being ahead of schedule.

The “Trend Line” will help you better understand your burn down data by averaging out the “Actual” line data. From the diagram above we can see that this particular piece of work is running about 20-25% behind schedule. The “Done Today” bars simply show how many story points were completed each day.

You can see that this piece of work has 5 days to finish, and as we’re trending approximately 25% behind schedule, it is going to take an Herculean effort to finish all the work in time. Ultimately, a burn down chart provides a great method of instantly seeing the status of a piece of work.

Although burn down charts are most commonly associated with Agile software development, where you use them is only limited by your imagination. For example, I have used them for:

  • Risk Management: to visualize how total risk is trending during a project.
  • Issue Management: to visualize how total issues are trending.
  • Bug Management: to visualize how end-to-end defects are trending at a program level.

For project managers burn down templates can be invaluable. If you found yourself managing a project made up of multiple sprints and in the first 2-3 sprints the team(s) were consistently 20% behind the planned output the recommendation would be to inform your steering group that the project is likely to be late or something will need to be dropped from scope.

I’ve uploaded a Burn Down Chart Template for you to download and use in your projects and programs. The template is an Excel file. Enjoy.

Cite this article

Minute Tools Content Team, Burn Down Chart Template, Minute Tools, Aug, 2011, https://expertprogrammanagement.com/2011/08/burn-down-chart-template/
Click to copy
author image

Denis G.

Originally hailing from Dublin, Denis has always been interested in all things business and started EPM in 2009. Before EPM, Denis held a leadership position at Nokia, owned a sports statistics business, and was a member of the PMI's (Project Management Institute’s) Global Executive Council for two years. Denis now spends his days helping others understand complex business topics.

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

cta image

In our course you will learn how to:

This 5-week course will teach you everything you need to know to set up and then scale a small, part-time business that will be profitable regardless of what’s happening in the economy.

So if you’ve always wanted to be your own boss and have the flexibility and freedom that entails, then…

Do your future self a favor and check out our course designed to help you achieve exactly that.

Learn more about our course