I am trying to create burndown for defects based on the due date, in the chart today also must be marked and deadline must be given by a line in the chart as 30-Apr-2020. can anyone please help.thanks. i attached excel file for the same.
I am trying to create burndown for defects based on the due date, in the chart today also must be marked and deadline must be given by a line in the chart as 30-Apr-2020. can anyone please help.thanks. i attached excel file for the same.
Hello vignesh1986 and Welcome to Excel Forum.
Not sure what happened to the file that was originally attached to post #1, however the attached copy of that file (below) may help answer your query.
Notice that the chart is a scatter chart and that the 'Today' line is populated according to the instructions of the tutorial linked below.
Notice that the deadline marker is manually formatted.
https://peltiertech.com/Excel/Charts...ertSeries.html
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks