My data is formatted as uniquely identified yes/no questionnaires. I'm attempting to display a chart that shows questionnaires that have answered all yes v. those that have one or more "no" responses. I've attached a workbook for reference.
So for example in the screen shot below, the data points on the far right currently show 8 - yes / 2 - no. I'd like it to display 6 - yes / 2 - no.