A vertical axis displays the amount of work still to be done, while a horizontal axis displays the amount of time from the project’s start, representing the past and the future. The burndown chart is visible to all members of the agile project management team and is updated to ensure accuracy. Microsoft distributes MS Excel, a commercial spreadsheet programme, for Windows and Mac OS operating systems. ..

To create a burndown chart in Microsoft Excel, follow these steps:

  1. Open the Microsoft Excel spreadsheet you want to work with.
  2. On the left-hand side of the spreadsheet, click on the Tools tab.
  3. Click on the Chart Tools button.
  4. On theChart Tools tab, click on the Burndown Chart button.
  5. In the resulting window, you will be asked to select a data source for your burndown chart. You can either choose to use your own data or use one of our recommended data sources. We recommend using our recommended data source because it is easy to work with and has a lot of features that are useful for burndown charts. If you choose not to use our recommended data source, you can still create a burndown chart by following these steps:
  6. In the Data Source field, enter your own data or one of our recommended data sources that we have recommended for you in step 5 above.
  7. Click on OK to close the Chart Tools window and return to your spreadsheet main screen where you can continue working with your spreadsheet as usual!

Steps to create burndown chart in Microsoft Excel

Step 2: Under the remaining work hours, select a blank cell, select cell A10, type “Deal remaining work hours” into it, and in cell A11, type “Actual remaining work hours” into it.

Step 2: Beside the A10 cell, type this formula =SUM(C2:C9) into the cell C10. Press Enter key to get the total working hours. ..

Step 3: In cell D10, type the formula C10-($C$10/5). Then drag the autofill handle to fill the range you need.

Step 4: Now go to cell C11 (which is beside the cell type “Actual remaining work hours”), and type the total working hours into it.

Step 5: Type this formula =SUM(D2:D9) into D11, and then drag fill handle to the range you need.

Step 6: Click on the Line button to insert a new line into the text.

To create a line chart, right-click on the chart and select “Select Data.” ..

Step 8: In the Select Data Source dialog, click the Add button to open the Edit Series dialog. Select “Deal remaining work hours” as the first series. ..

Step 9: Click OK to go back and select the Data Source dialog. Step 10: Click Add button again, then add “Actual remaining work hours” as the second series in the Edit Series dialog.

Step 10: Click OK, go back to the Select Data Source dialog, click the Edit button in the Horizontal (Category) Axis Labels section, then select Range C1:H1 (Total and Dates labels) to the Axis label range box in the Axis Labels dialog. ..

The burn down chart has been created.

You can click the chart then go to Layout tab and click Legend > Show Legend at Bottom to show the burn down chart more professionally.

Final Words

To create a burndown chart in Microsoft Excel, follow these steps:

  1. Open the Microsoft Excel spreadsheet you want to use for the burndown chart.
  2. On the left-hand side of the spreadsheet, click on the Tools tab and then click on Data Analysis.
  3. In Data Analysis, click on the Burndown Chart button.
  4. In the Burndown Chart dialog box, enter a name for your burndown chart and then click on OK.
  5. Click on OK to close the dialog box and return to your spreadsheet.