You could create a pivot table to summarize the data, and create a chart
from the pivot table results.

There are instructions for pivot tables in Excel's Help, and Jon Peltier
has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html