Hello:

Thanks in advance as I'm new to this group. I'm trying to create a graph of sorts that shows daily trends for results from a testing workshop. If a graph is not possible is there another way within the spreadsheet to identify all changes daily.

Example:

Day 1 - 3/1/21
· Open Test Cases: 89
• Ready for Retest 24
• Resolving 17
• Test\Failed 3
• New Defects 15
• New Test Cases 22
• 8 Resolved

Day 2 - 3/2/21
· Open Test Cases: 79
• Ready for Retest 32
• Resolving 10
• Test\Failed 1
• New Defects 8
• New Test Cases 15
• 13 Resolved