+ Reply to Thread
Results 1 to 2 of 2

Burndown for defects

  1. #1
    Registered User
    Join Date
    01-01-2017
    Location
    India
    MS-Off Ver
    MS office 2016
    Posts
    1

    Burndown for defects

    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.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: Burndown for defects

    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.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 12
    Last Post: 07-21-2019, 03:24 PM
  2. Replies: 4
    Last Post: 04-10-2019, 10:29 AM
  3. Replies: 4
    Last Post: 11-26-2018, 01:00 AM
  4. VBA - Getting application error code 1004 when trying to fetch defects from QC 10
    By Aki1403 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-06-2016, 03:37 AM
  5. Need a chart similar to a burndown
    By nagarajav in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-10-2014, 10:18 PM
  6. Pie Chart Defects
    By mycon73 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-14-2011, 11:29 AM
  7. Backlog and Burndown sheets
    By racinjason1978 in forum Excel General
    Replies: 2
    Last Post: 04-07-2008, 05:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1