I have a list of days in one column. So, for every date entered, I have a corresponding day i.e. either Monday or Tuesday or Wednesday etc. Now, in this column I have days of the week. How would I be able to quantify percentage of each given day from lets say 100 or 200 cells ? i.e. If I need a pie chart depicting how many Mondays, Tuesdays, Wednesdays etc. are there from the total as a percentage, how would I generate such a chart from this one column's data ?
Thanks
Bookmarks