Pie Chart Displaying Only Data Where a Condition is Met

I have the following excel data where each row reprsents a task assigned to an individual. I need to display a pie chart to show the proportion of these outstanding tasks for each individual where the task has not been completed. That is, I only want the chart to display data where Col B is "No".

COL A | COL B
Assigned To | Completed
John | No
Amy | No
Bill | No
John | Yes
John | No
Amy | No


More individuals are also being added all the time. I therefore need a solution that examines col A to count the number of incomplete assigned tasks for each individual, ideally without having to manually add another row to another table with entries for each individual with a cell to COUNT each.

In summary, I need a pie chart that displays, in the example above, the 5 relevant entries (where "No" applies), showing 2/5 for John, 2/5 for Amy and 1/5 for Bill. But then I need to be able to add new entries, say for "Sarah" and for the pie chart to instantly reflect this: 2/6 John, 2/6 Amy, 1/6 Bill, 1/6 Sarah

I hope this is clear. Any questions, please ask. Thank you.

Originally Posted by JosephP

have you tried a pivot chart?

also just be aware that pie charts are not generally well regarded in the world of data visualization :-)

No, have not tried a pivot chart. I'm not sure how to be honest. Any advice please?

I'v been asked to create a pie chart.

Originally Posted by JosephP

select the data
choose insert tab, then pivot chart (from the pivot table dropdown)
follow the wizard to create the pivot table and chart where you want them
change the chart type to pie
drag the 'Assigned to' field to the axis area
drag the Completed field from the list to the value area
drag the Completed field from the list again but this time to the report filter area and then select the No value using the dropdown on the chart

Your attached example is just what I'm trying to do. I can't thank you enough. I'm just struggling to repeat your steps within Excel 2003 (sorry, should have noted this previously). I can't see where the report filter area is. Thanks again.

Many thanks for all your help.