Hi everyone,

I am new here and just a bit familiar with Excel, but I cannot for the life of me figure out how to combine a couple of pieces of data for a report. What I have so far are my call center's calls per hour this year and calls per day of the week. I realize I may just end up with averages, but I need to get something to show the busiest days/hours in 1 chart so I can plan coverage.

I've tried to add them both into a pivot chart, but I can't get them to work. It only shows me either calls per hour or calls per day of the week. Any help/hints would be greatly appreciated.

HOUR Calls
0 146
1 89
2 111
3 120
4 269
5 658
6 1251
7 1264
8 1922
9 1872
10 1602
11 1461
12 1569
13 1276
14 1393
15 1345
16 1106
17 527
18 313
19 313
20 599
21 1095
22 1015
23 323

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
538 4228 3869 5285 4119 3162 438