AJP Excel Information

RE: Yes No count using named range

Named formula

ChtData:

=CHOOSE(ROW(Sheet1!$1:$2),COUNTIF(Sheet1!$A$2:$A$21,"Yes"),COUNTIF(Sheet1!$A$2:$A$21,"No"))

Chart Series formula

=SERIES(,{"Yes","No"},ng54.xls!ChtData,1)

Example file