How to Create a Budget Burndown Chart in Excel – 3 Steps

 

STEP 1 – Prepare a Dataset

This is the sample dataset. It showcases Total Work, Estimated Progress, and Dates.

budget burndown chart excel


STEP 2 – Enter the Actual Task Progress in Dataset

  • Enter the value of the remaining task at the end of each day in Column E.

Enter Actual Task Progress in Dataset


STEP 3 – Create a Budget Burndown Chart in Excel

  • Select the Date, Estimated, and Actual Remaining Task columns.
  • To select non-adjacent columns, select any column and hold Ctrl.
  • Release Ctrl.

Generate Budget Burndown Chart in Excel

  • Go to the Insert tab and select Insert Line in Charts.
  • Select a type of line chart. Here, a 2-D line chart.

  • The Budget Burndown chart is displayed.
  • The Orange color indicates the pending percentage of tasks.
  • The Blue color represents the remaining estimated tasks.


Final Output

  • Rename the chart: Budget Burndown Chart.

budget burndown chart in excel

Read More: How to Create a Burn-up Chart in Excel


Download Practice Workbook

To practice by yourself, download the following workbook.


Related Articles


<< Go Back to Burndown Chart in Excel | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sudipta Chandra Sarker
Sudipta Chandra Sarker

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo