MS Excel Template Agile SCRUM Sprint Burn Down Chart Table & Burn Up Chart where no access to Agile tools like Jira

Overview

An example MS Excel template (editable) Agile Burn Down Chart and Burn Up Chart where there is no access to Agile tools like Jira. Tailor this Excel spreadsheet as appropriate for your Agile Scrum project.

Benefits

1. A quick and easy way to construct burn down and burn up tables and charts for your Agile Scrum project.

2. Very useful for client and internal stakeholder reporting or as part of status reports, especially when tools like Jira are not installed.

3. Editable and tailorable for your own Agile Scrum project Sprint lengths and saves time building from scratch.

Tab 1: Contains the Agile Sprint burn down chart table of points burned for a particular Sprint. The Sprint shown is a 2-week duration (probably the most typical duration for a Sprint). Amend this for Sprint length and add the context of the tasks and points per task as appropriate. For each Sprint in the Agile project, just copy this tab and increment to the next Sprint cycle and repeat.

Tab 2: The Sprint burn down chart for the table in Tab 1 above. This provides the graphical view of the Sprint in terms of forecast and actual story points burned. Copy and rename to the subsequent Sprint as required by creating a new worksheet tab.

Tab 3: The burn up table represents the forecast and actuals across the whole Agile Scrum project by story points.

Tab 4: The burn up chart for Tab 3.

About the Author: A Senior Project Manager with 31 years of experience in delivering projects, a PRINCE2 Practitioner and experienced in Agile SDLCs.

This Best Practice Includes:

1. Multi-Tabbed Excel File

Objectives

1. A quick and easy way to construct burn down and burn up tables and charts for your Agile Scrum project.

2. Very useful for client and internal stakeholder reporting or as part of status reports, especially when tools like Jira are not installed.

3. Editable and tailorable for your own Agile Scrum project Sprint lengths and saves time building from scratch.

Use It If:

MS Excel template (editable) Agile Burn Down Chart and Burn Up Chart where there is no access to Agile tools like Jira. Tailor this Excel spreadsheet as appropriate for your Agile Scrum project.

Don’t Use It If:

Your organisation already uses another tool for this, like Jira.