Thank you Narayan.Hi ,
Excel does not display chart values which have been filtered out.
If you can put a filter on column B selecting only Yes values , the chart will display only those values. All No values will be ignored.
See the attached file.
Narayan
Thank you Peter. No it was not coincidence.Was it just a coincidence the "No"es corresponded to zero values?
If one wishes to filter by formula rather than by interaction with the worksheet, the values are easier to work with than the text.
For example, using a new function available in Office 365, and could define filtered arrays using named formulae
= FILTER( Sheet1!Names, Sheet1!Values )
= FILTER( Sheet1!Values, Sheet1!Values )
so that the chart series formula becomes
=SERIES(,Sheet1!filteredNames,Sheet1!filteredValues,1)