Forum Discussion

FrankWoody's avatar
FrankWoody
Icon for Helper I rankHelper I
4 years ago

SOME IDEAS HOW TO DO BURNDOWN CHART

PROJECTFIRST STEPFIRST STEP DONE BASE DATEDATE COMPLETEDSECOND STEPSECOND STEP DONE BASE DATE DATE COMPLETED 
AYESYES 17/01/202225/01/2022YESYES25/03/202212/02/2022
BYESNO17/02/202210/02/2022YESNO  
CNO   YESYES25/04/202220/04/2022
DNO   YESYES25/05/202230/05/2022
EYESYES 17/03/202224/04/2023YESNO  

 

Evening! 
to me it's a big challenge the first time that I try to do burndown chart.
I've a list at excel with some projects that have 5 steps, put in this example a put just two of them. I'd like to do a burndown chart of each step and burndown that represent the total of the project. 
First and second stages show if the project needs to go through this stage or not. 
Completed first and second stage indicates the completion of the project
Base date is the date you expect the project to be completed

I'm modeling the base of the data so if you have some advices that the batter way to organize the data it will hep.