Project Management

Please login or join to subscribe to this thread

Does anyone have burn down / burn up templates available?

linkedin twitter facebook   Agile  
avatar
Joseph Newberry Program Manager, PMP, PMI-ACP, SA, CSM| Agere Contracting, LLC Woodbridge, Va, United States
Looking for spreadsheet templates of burn down and burn up charts.
Sort By:
avatar
Kiron Bondale Retired | Mentor| Retired Welland, Ontario, Canada
Joseph -

There don't appear to be any in the Templates section of this community but a quick Google search revealed a few including:

1. https://agile-mercurial.com/excel-templates/burndown-chart/
2. https://www.automateexcel.com/charts/burndown-template
3. https://chandoo.org/wp/burn-down-charts/

I haven't used any of these so can't comment on their quality.

In general, most clients I've worked with would be using a work management solution such as Jira or Rally which can automatically generate these charts based on the work item updates done by team members.

Kiron
...
1 reply by Joseph Newberry
Feb 15, 2021 2:31 PM
Joseph Newberry
...
Thank you Kiron.
avatar
Keith Novak Tukwila, Wa, United States
You're better off looking at examples for formatting ideas, and building your own. Your data will be structured differently, you probably want to show different things, and it is a major pain trying to reverse engineer someone else's spreadsheet and the modify it to suit your needs. Once you know what you want to show, the biggest trick is adding additional data series using a combo chart format.

The basic characteristics are the things you're counting (those can be total or grouped using stacked bar charts such as late items by team for example), the goal line (not necessarily zero even in a burn down), and the planned progress line which could be linear, stair step, etc.
avatar
Verónica Elizabeth Pozo Ruiz RYLAI Access Control Quito, Pichincha, Ecuador
You can find a general burndown and burnup chart generator at this link: https://printyourburndown.com/.
If you prefer a more complete management dashboard, I recommend a solution called TeleworkingMonitoring that combines agile supervision of tasks in Trello with Global Management Indicators in Power BI. You can contact them at [email protected], or send a message on the page: https://www.facebook.com/Teleworking-Monitoring-107369664431280
avatar
David Portas London, United Kingdom
My suggestion is that you do a Product burn up chart, not burn down.

https://github.com/dportas1/docs/raw/main/Burn%20Chart.xlsx

Avoid producing Sprint burn charts. Even with the best of intentions, sprint burn charts just suggest micro-management (or maybe your sprints are too long). Monitoring the burn rate during sprints rarely tells you much anyway.
...
1 reply by Joseph Newberry
Feb 15, 2021 2:35 PM
Joseph Newberry
...
Thank you David.
avatar
Joseph Newberry Program Manager, PMP, PMI-ACP, SA, CSM| Agere Contracting, LLC Woodbridge, Va, United States
Dec 01, 2020 2:46 PM
Replying to Kiron Bondale
...
Joseph -

There don't appear to be any in the Templates section of this community but a quick Google search revealed a few including:

1. https://agile-mercurial.com/excel-templates/burndown-chart/
2. https://www.automateexcel.com/charts/burndown-template
3. https://chandoo.org/wp/burn-down-charts/

I haven't used any of these so can't comment on their quality.

In general, most clients I've worked with would be using a work management solution such as Jira or Rally which can automatically generate these charts based on the work item updates done by team members.

Kiron
Thank you Kiron.
avatar
Joseph Newberry Program Manager, PMP, PMI-ACP, SA, CSM| Agere Contracting, LLC Woodbridge, Va, United States
Dec 01, 2020 4:42 PM
Replying to David Portas
...
My suggestion is that you do a Product burn up chart, not burn down.

https://github.com/dportas1/docs/raw/main/Burn%20Chart.xlsx

Avoid producing Sprint burn charts. Even with the best of intentions, sprint burn charts just suggest micro-management (or maybe your sprints are too long). Monitoring the burn rate during sprints rarely tells you much anyway.
Thank you David.

Please login or join to reply

Content ID:
ADVERTISEMENTS

If trees could scream, would we be so cavalier about cutting them down? We might, if they screamed all the time, for no good reason.

- Jack Handey

ADVERTISEMENT

Sponsors