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
Bookmarks