Add chart using formula

S

sharmila

New member
Joined
Jan 29, 2015
Messages
2
Reaction score
0
Points
0
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:
Capture.PNG

  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?
 
You must log in or register to reply here.
Back
Top