In one cell, use the formula =COUNTIF(A1:A100,"=YES"). In another,
=COUNTIF(A1:A100,"=NO"). Build your graph from the results of those two
cells.

Hope this helps.

Jane

"Dahlman" wrote:

I have a column titled "On time" the entries underneath this title are
either"Yes", "NO", or "NOT COMPLETED". I want to create a pie chart with the
percentages of Yes and NO.

Please help. Thanks in advance.