I wanted some help in excel as i have low expertise in it. Below is a screenshot of my data for which i need to add a formula in generating a graph.
I have four columns in an excel:
Click image for larger version. 

Name:	Capture.PNG 
Views:	19 
Size:	11.7 KB 
ID:	3117


  1. Execution status dropdown has values "Pass" or "Fail". Based on the values selected here i using a formula to generate 'Overall status" (Formula used = =IF(COUNTIF(J2:J14, "Pass")=, "Pass", "Fail").
  2. Now, i wanted to generate a chart for Requirement and OVerall status column. This is something that im not able to do.

I need to generate a chart saying for Requirement 1 there is one pass and one fail. and for requirement 2 there are 3 fails and 2 Pass.
Can someone help me out in this?