Hiya. I have a spreadsheet with the columns

ID (unique)
Title
Done (yes/no)
Done on (date - empty if Done is no)



This sheet has x number of rows.

I want a burn down that will allow me to show progress over time to the goal of x being done by EOY (12/31/2019) with a data point for each month.

Can anyone tell me how to do this as I am quite new to Excel shenanigans of this sort. Thanks!

Please post a sample sheet (no pics please) with some data and expected results. Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I would LOVE to but cannot see how to attach a file.

Let's see if I figured my drive right. Worst case, I have accidentally shared my grocery list.

So if you can get to the workbook, you will see data. ANd on one sheet is a pivot table and chart. My chart is getting close. I want each point to be the total as of that month. So Jan's point would be 5. Feb's point would be 34. I could then increase the y-axis to go to my fixed total and just draw a fixed line there.

Does that make sense?

Thanks

To attach a file click Quick Reply - go advanced - follow the wizard ( external links are notoriously unsafe and not all members can/will access them)


And BTW we have a nice FAQ feature where lots of things are explained...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

here it is

Attached Files

TestCaseStatus.xlsm (28.2 KB, 17 views)

Well now I have learned something new. I would not want to click an external link either! Thanks for the info.

And I was moronic and posted a macro enabled workbook which no one will open. Erg.

Attached Files

TestCaseStatus.xlsx (28.2 KB, 10 views)