Initial Burndown Chart $($Submission$)$

Open a new sheet in Excel and create columns as per your project$$s needs.

We$$ll lay the groundwork for the work burndown chart with a table. This will contain your basic information on time and the tasks remaining.

For the tasks, split it into two columns, representing the number of remaining tasks you estimate you$$ll have $($your planned effort$)$ and the actual tasks remaining on that day.

You can add details to this table for your work burndown chart, such as:

The name of each product backlog item

Story points

Estimated effort $($in hours$)$

Actual effort $($in hours$)$

Remaining effort $($in hours$)$

Step $2$: Add data in the planned column

We$$ve assumed an ideal burndown rate of one task or user story per working day.

Make sure the start date is February $1,2024.$

We$$ve not accounted for weekends, and hence the number of tasks doesn$$t reduce on Saturday and Sunday in this table.

Note: You$$ll have to manually update the Actual column at the end of each day to reflect the number of tasks that actually remain.

Now, we add our values to the planned column, representing how many tasks you ideally want remaining at the end of each day of the $10-$day sprint.

Remember, this is an ideal scenario.

So whatever numbers you add here do not account for any real$-$world complications that your team may face in the sprint duration.

Step $3$: Generate a chart

To do this, follow these steps:

Select the $$Dates$,$Planned$,$Actual$$ and 'Acticity' columns

Click on Insert in the top menu bar

Click on the line chart icon

Select any simple line chart from here

Once you$$ve assembled your hard$-$earned data in one place, Excel will take over the rest of your process!

To do this, follow these steps:

Select the $$Dates$,$Planned$,$ and $$Actual$$ columns

Select any simple line chart from here