Published on: March 20, 2018
Free Excel Burndown Chart Template from Hot PMO

We offer the best PMO templates for free

PMO people spend a lot of time creating templates. This generally for the following reasons:

  • Standardization – having a consistent format or structure across a program or organization means it is easier for people to operate across teams without having to relearn. It also means other areas of the business who work with the entire portfolio of project teams know what to expect, and where to find the information they need
  • Quality – Often in software delivery projects, accuracy is important. Small errors can quickly multiply and have major ripple effects across teams. Templates can be used to build quality into the process. Examples of how the PMO can build quality into templates include – adding prompts or mandatory fields to prevent accidental omission and adding calculated fields to cross-check data for errors.
  • Speed – Templates can speed up delivery by reducing the amount of time taken to ‘reinvent the wheel’. If one team has an example of good or ‘best’ practice, then It can be standardized and used across multiple agile teams.

Free Scrum Burndown Chart in Excel

I have been asked if I have a template for creating a burndown chart in Excel. Well yes, I have, and here it is! Many teams using Scrum use burndown charts as a tool to measure velocity. While many tools such as Jira and Trello include burndown chart functionality, it is useful to create your own version to see how it works and check your calculations.

Image of an Excel Spreadsheet containing an agile burndown chart.

Agile Burndown chart in Excel

Click on the image to download a simple template that will generate a simple burndown chart. The sheet uses Excel’s built-in tables functionality to create a simple burndown chart containing a list of features and progress by the day.

But that’s not all! The template also includes a simple Kanban chart, allowing you to see at a glance how many stories are still in the Backlog, In Progress or Done.

The sheet is designed to work with Excel 2016 and above, as it uses the new waterfall chart type to generate the Kanban chart. If you are on an older version of Excel, you should still be able to use the template, but you will need to change the chart type for the Kanban chart to make it a Histogram (Bar chart).

How to use this burndown chart

Download the sheet by clicking on the image below. Populate the table with your features, Estimated hours and Status. The priority column is optional and can be used to easily sort your data. The ‘Status’ drives the Kanban chart: Features can either be in the Backlog, In Progress or Done. The ‘Status’ does not affect the Burndown chart. Track the actual hours worked by day as you go through your iteration. The Burndown will update automatically based on the data in the calculated cells in E2:J4. The chart can be expanded vertically to add more features without any changes to formulae.

This burndown chart is free of Macros and VBA!


Submit a Comment

Your email address will not be published. Required fields are marked *