Thread: help creating piechart

I have a test excel file attached here and would like to know how i create a piechart that would show stats of how many times each member turned up to our meetings.

each member would be shown in the chart as a seperate colour and have the count of times attended overall

but...

for each of the types of meetings.

there are three types

meet1, meet2, meet3

each meeting i would like to have its own chart

p1, p2, p3, p4 are the peoples initials i.e. AB, CB, DE, FG

and in the sheet the 'P' is present and 'A' is absent

what i do not understand is how i get the chart to count for all rows where each member has turned up for meet1, meet2 and meet3 accross the whole sheet?

can someone tell me how they would do this or where i would start, as i would like to learn how this is done instead of having it done for me. !

thanks

hey thank for your reply

i been digging around and found the countif function but could not work out how to count only if the field had 'P' and was in the rows that also has 'meet1'

ok playing around with stuff and come up with this, but it counts all of the 'P' and not just ones in the rows with 'meet1'