counting trends over time - by hour, and by day

GoodQueenBess

New Member
Joined
May 23, 2019
Messages
2
Please forgive my appalling lack of Excel vocabulary. I'm not even sure what what I'm trying to do is called. :)

I have a spreadsheet to track the time and frequency of occurrences, say phone calls. My data is like:

Weekday Date 9:00 hour 10:00 hour 11:00 hour
M 5/15 99 5 0

I'm looking for a dynamic (?) chart to track:
Weekday 9:00 hour
(all Mondays) frequency of occurrence per hour

The idea is to get a look at how busy various hours are. For instance, is the 3:00 hour always the busiest? Or just on a couple days of the week?

I want it to update as I enter the data for each week.

(Once I have this figured out, I'm gonna try it to tell me which days are overall the busiest and have that update as well.)

Thanks!
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

GoodQueenBess

New Member
Joined
May 23, 2019
Messages
2
BTW, I'm kind of thinking of a column chart - scatters are a little difficult for me to interpret.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,286
Messages
5,443,571
Members
405,238
Latest member
siddo

This Week's Hot Topics

Top