PLEASE HELP!
I have data for appointments booked at differnt veterinary branches. I'm trying to find a way to see how many appotinments are booked on each day of the week and at each branch. I can easily create a chart to see the count of appointments booked at branch a, b and c or a count of the appointments on each day, but I can't find a way to break this down to how many in each branch on each day (I hope this makes sense!).
So for example, on the attached sample data I can see that on a Monday there are 2 appointments both in branch A and on a Friday there are 2 appointments in total but one in branch C and one in branch B. I obviously have signifficantly more data so am hoping there is an easy way to produce a chart for this in excel.
Thanks a million in advance for your help!
Bookmarks