Formulas for burnup/burndown chart

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I currently have.

Each row in my table is a task record, and below are the columns that are relevant for the charts I’m trying to create.

The burndown chart x axis will contain the start date of each week and track planned against completed.


Start date

Planned due date

Actual expected

Total No of Planned days

Total No of Actual Days

(if different to planned)

Percent completed



By: Hah

Leave a Reply

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