Agile Scrum Sprint Burn Down Chart & Burn Up Chart Template (Excel XLSM)

BENEFITS OF THIS EXCEL DOCUMENT

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 not installed.
3. Editable and tailorable for your own Agile Scrum Project Sprint lengths and saves time building from scratch.

PROJECT MANAGEMENT EXCEL DESCRIPTION

This product (Agile Scrum Sprint Burn Down Chart & Burn Up Chart Template) is an Excel template (XLSM), which you can download immediately upon purchase.

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.

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 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.

Source: Best Practices in Project Management, Agile, Scrum Excel: Agile Scrum Sprint Burn Down Chart & Burn Up Chart Template Excel (XLSM) Spreadsheet, i_Pro_PM_Templates