I run a volunteering program where volunteers visit seniors in care homes. Each time a volunteer visits, they complete a survey that shows me the date of the visit and the time they spent with the senior.
I want to find the top 20% of volunteers in 1) their number of visits and 2) their total volunteering time in minutes.
I did some research and wanted to make a cumulative frequency graph to do so. However, I have over 7000 individual survey entries.
After downloading that data, the table looks like Figure 1. What can I do to get frequency graphs, like Figures 2 and 3, for thousands of entries?
Figure 1. Mock survey entries of volunteer hours Figure 2. Number of visits Figure 3. Volunteer time
I have basic knowledge of Excel. I've tried using Pivot Tables. Would I need PowerQuery, Macros, etc. to do so?
Any advice will be helpful. Thank you!