Need a chart similar to a burndown

I have a Pivot that captures
Project, amount of work remaining in days, days remaining in the project (project end date - now() ). I do not have any specific date fields to use in a series.

I need a chart that shows something like a burn down. Dates till Project end date in X-axis, Amount of work in Y axis, and a line indicating by what date we can burn down all the work. Can this be done without any manual data entry?