Need a chart similar to a burndown

[nagarajav]

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 (line chart). 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?

Example Data

Key	Summary	Assignee	Updated	Remaining Estimate in days	Project	Start Date	End Date	Days remaining
Item1	Task 1	Person A	11/7/14	12	Project 1	11/3/14	11/28/14	17
Item2	Task 2	Person B	11/7/14	13	Project 1	11/3/14	11/28/14	17

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

My current pivot table

Row Labels	Max of Days remaining	Sum of Remaining Estimate in days
11/28/14	18	25
Grand Total	18	25

<colgroup><col><col><col></colgroup><tbody>
</tbody>