Burn up for my time line

[vthomeschoolmom]

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!

[Pecoflyer]

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

[vthomeschoolmom]

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

[vthomeschoolmom]

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

[vthomeschoolmom]

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

[Pecoflyer]

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...

[vthomeschoolmom]

here it is

[vthomeschoolmom]

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

[vthomeschoolmom]

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