Make a pivot table for hourly head count of members in the gym to see "busy times".

Hello everyone,

I have attached a table that we use at our gym in order to count the amount of members in the gym every hour on the hour. Trying to tidy up the data and possibly make charts to show the busy times for each hour and have a separate chart for each day of the week. I hope that is clear enough. Looking to have something similar to what Google has for business hours where you can see what time of day is the busiest.

Thanks for any help!